Lookup
Hi
I’m using the lookup function to look for specific text and return the text in adjacent cell. The formula works. However ,2 of the phrases I’m looking for are : Apple and PPL , so Apple returns PPL. I’m using a range for my search criteria , how do I fix is it so it looks for the exact text ?
RE: Lookup
Hi RH,
Thank you for the forum question.
The Vlookup structure: =Vlookup(Lookup_Value, Table_Array, Column_Index_Number, Range_Lookup)
To find an exact match type False in the Range_Lookup argument (or 0).
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Lookup
Thanks
I wasn't clear enough. Here's the formula I used
=LOOKUP(2^15,SEARCH($L$3:$L$8,C2),$M$3:$M$8)
Search for Return
Apple Apple
APP APP
There additional text in the search range, I am just looking for specific text
Thanks
RE: Lookup
Hi RH,
Microsoft suggest that we are not using the Lookup function. It is very memory consuming and slow down everything. The Lookup function lookup a range not exact match.
I have attached a workbook with a suggestion to do the task.
(I hope that I have understood what you need)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
lookup.xlsx
