A Challenging One

[Frank Bacchus]

I have a spreadsheet (attached) with the following Columns:
ITEM, Partial Field, FullDesc, Row, Found Where

Partial Field is a partial subset of ITEM. I am trying to use the content of Partial Field to see if it exist in the FullDesc (C2:C218) rows. If it exists I would like to return the associated value that's in Row and place it in the Found Where cell. My current formula is: =IF(ISNUMBER(SEARCH(B2,$C$3:$C$218)),D2,"") which doesn't seem to work. Any help in making this work or other alternatives would be gladly appreciated.

thanks

frank

 

[bosco_yip]

Hi,

Here is the formula and helper column is not required

E2, copied down :

=IF(B2="","",IFERROR(LOOKUP(1,0/FIND(B2,C$2:C$219),ROW(C$2:C$219)),""))

Regards
Bosco