Notifications
Clear all
Topic starter
Hi,
I want to be able to vlookup a key word within a lot of text in a cell. IE Column A I want to lookup the column for "TOWER"
Thanks in advance for the help.
| A | B |
| MOBILE: LIGHT TOWER | 07047N |
| MOBILE: LIGHT TOWER | 07047N |
| CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W | 47028N |
| CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W | 47028N |
| CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W | 47028N |
| POWER SUPPLY ASSEMBLY, TYX | 63026N |
| POWER SUPPLY ASSEMBLY, TYX | 63026N |
| POWER SUPPLY ASSEMBLY, TYX | 63026N |
| POWER SUPPLY ASSEMBLY, TYX | 63026N |
| PROJECTOR/REVIEWER/EDITOR | 70014N |
| SCREEN PROJECTION UNIT | 70019N |
| SCREEN PROJECTION UNIT | 70019N |
| SCREEN PROJECTION UNIT | 70019N |
Posted : 02/06/2020 1:04 pm
Hi Kev
You can wrap what you are looking for in * (wild card)
Index & match - =INDEX($B$2:$B$14,MATCH("*"&E2&"*",$A$2:$A$14,0))
Or
VLOOKUP - =VLOOKUP("*"&E2&"*",$A$2:$B$14,2,FALSE)
Purfleet
Posted : 03/06/2020 1:16 am
