Hi,
i'm trying to work on a way to lookup the values in a cell(comma separated) and return multi values.
this is the formula i'm trying to use, and if i go in the formula it looks like it is find the correct values but is showing error in return
=TEXTJOIN(",",TRUE,IF(ISNUMBER(SEARCH('ENOVIA LU'!AB:AB,VLOOKUP(CALC!B4,ENOVIA!A:IJ,244,0))),'ENOVIA LU'!AC:AC,""))
i also attached the file,Formula is on Sheet "CALC"
my expected result in the formula would be 100,101,102,103, which corresponds to the looked up values A,B,C,D
can anyone support me on this?
Bookmarks