Thread: [Solved] update master list automatically from other worksheet
View Single Post
 
Old 08-22-2017, 06:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try updating formula:

=IFERROR(IF(SUBSTITUTE(LOOKUP(2,1/((ISTEXT($Z17:$AO17)*($Z17:$AO17<>""))),$Z17:$AO17 ),"","")=B$15,1,""),"")
Reply With Quote