Formula for finding text
Hi,
Use vlookup() but before you do sort the list into ascending order based on
Col A.
Regards
Paul
"Simon" wrote in message
...
What formula should I use to lookup a piece of text from a
list of entries in for example colomn a I want to lookup
apple and if found then return the data from colomn b i.e.
AP into cell 5a.
A B
1 Potato PO
2 Carrot CA
3 Apple AP
4 Swede SW
5 Formula result
It sounds simple but I can only get matches to work with
numbers and not text. Any ideas?
Thanks
|