VLOOKUP with Wildcards...

[Aitch]

How do I use the VLOOKUP function with wildcards?

=VLOOKUP(B2 ,

Where B2 may have something before or after - so like *B2*

I've tried this with no luck!

=VLOOKUP(&"*"& B2 &"*"&


Thankyou for any help!

 

[Toadstool]

Hi Aitch,

Yes, your wildcard should work but remember it will only find the first occurrence and it will find matches in the middle of words.

Aitch3.xlsx
	A	B	C
1	Text	Lookup	Result
2	The cat sat on the mat	Dog	Who let the dogs out?
3	Who let the dogs out?	Pig	The pig snorted
4	The pig snorted	Rat	He ingratiated himself
5	He ingratiated himself
6	The big dog slobbered
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=VLOOKUP("*"&B2&"*",$A$2:$A$10,1,0)