=IF(ISNUMBER(SEARCH(.... using lookups?

[jessic@]

Hi all,
On the attached spreadsheet I want to enter a formula in cell B3 that says - if A3 contains any of the values listed in column E then enter the adjacent value shown in column F.

This is just an extract from the spreadsheet, the actual "contains" list includes over 100 items so repeating "=IF(ISNUMBER(SEARCH(E3,A3)),F3)" 100 times would mean a huge formula.

Is this possible?

Thanks!
J

[XOR LX]

Hi,

You don't say what the result should be if the Description contains more than one of the search strings (e.g. 8888 13FEB14 , MORRISON PETROL , 0 GB), but, in B3 and copy down:

=INDEX($F$3:$F$20,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($E$3:$E$20,A3)),,),0))

Regards

[jessic@]

Thank you!
I'll be able to work around Morrison and Petrol; they are the only two search strings that sometimes appear together.
Regards,
J

[XOR LX]

You're welcome!

[JekinMakwana]

This formula is also working for me, but can you please help me in understanding this formula by what value each function will return?