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