# VLOOKUP exact match found inside another word

#### cheweeman

##### New Member
Hello everybody,

The title is maybe a bit complicated but my problem is quite understandable.
I am looking an information in product codes. So my formula is:

=IFERROR(VLOOKUP("*"&\$A6,'day 08 29.xlsx'!\$A\$1:\$Z\$200,3,0),0)

A6 content is "009"
So if excel finds the content "009" in the row A of the workbook 'day 08 29' it should give me the information of the 3rd next cell. (Then if N/A it gives me 0).

My problem is that I have a cell that contains "2009" and whenever excel doesn't find 609 (because it doesn't exist in a table) and finds "2009" I get the information from "2009" instead of 0.

Where it come from (here, no "009", only a "2009")

Where it goes (here, the '2' asked for goes in "009" and "2009" cells

I don't know what to do.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Welcome to Mr Excel.

Why are you using a wildcard if you want an exact match?

Hello Andrew,

It doesn't work at all without a wildcard...

=IFERROR(VLOOKUP("*"&\$A2,'[day 08 28.xlsx]day 08 28'!\$B\$1:\$AA\$200,3,0),0)

=IFERROR(VLOOKUP(\$A3,'[day 08 28.xlsx]day 08 28'!\$B\$1:\$AA\$200,3,0),0)

Last edited:
Hello Andrew,

It doesn't work at all without a wildcard...

=IFERROR(VLOOKUP("*"&\$A2,'[day 08 28.xlsx]day 08 28'!\$B\$1:\$AA\$200,3,0),0)

=IFERROR(VLOOKUP(\$A3,'[day 08 28.xlsx]day 08 28'!\$B\$1:\$AA\$200,3,0),0)

It didn't work because as I corrected the code with trim, I was looking for the value in the 4th row and not the 3rd.
I will try to correct all the formulas.

Firsts formulas corrected and it works fine !
Thank you very much !

Replies
2
Views
201
Replies
3
Views
725
Replies
5
Views
496
Replies
2
Views
459
Replies
1
Views
302

1,219,672
Messages
6,149,618
Members
450,904
Latest member
Gracifer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back