Hi Fiona

Not sure I fully understand your question, but does the following do what
you want.
=IF(ISNUMBER(SEARCH(C1,A1:A3&B1:B3)),C2,"")

--
Regards
Roger Govier



"Fiona" wrote in message
...
Hi, I am trying to get a lookup formula to read 3 cells in one row, then
compare it to my look up list.

e.g, A1 is South A2 is East, A3 is London, B1 is London, B2 is England, B3
is UK

In C1 I have London and C2 I have LOND.

I want my formula to equal C2 if any of the cells A1 - A3 equal C1, and so
on.

Thank you in advance
Fiona