Extract Particular text mentioned in look up list

[uday]

Hi,

I am trying to extract only those values from Column A onto column B which are only available in my lookup list highlighted with yellow.

 

[azumi]

Hope this helps

 

[uday]

Azumi,

Can you please tell me, why you used 2^15 here?

Also, can I use vlookup instead of lookup?

 

[deciog]

In this case, according to his example, the formula can be simplified,

=IFERROR(LOOKUP(2^15,SEARCH($J$2:$J$5,A2),$J$2:$J$5),"")

Decio

 

[shrivallabha]

Azumi,

Can you please tell me, why you used 2^15 here?

Also, can I use vlookup instead of lookup?

2^15 equates to 32768.
Maximum number of characters a cell can contain is 32767.
So it exceeds the largest number that SEARCH function will possibly return.

 

[uday]

Thanks Azumi.

 

[uday]

Thanks Decio

 

[uday]

Thanks Shrivallabha