#### John Davis

##### Well-known Member

- Joined
- Sep 11, 2007

- Messages
- 3,457

It's been awhile since I used VLOOKUP with a wildcard. However, here is what I have.

In Column A Sheet1 I have a list of numbers. I'm trying to data from Sheet2 Column B. Sheet 2 Column A has the list of numbers.

=VLOOKUP("*"&A2&"*",Sheet2!$A$2:$B$6,2,FALSE) this returns #N/A

=VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE) this returns the correct result.

However, I need the wildcard since Sheet 2 Column A does not always have a direct match.

Can someone provide an explanation/guidance on what may be happening?