VLOOKUP exact match found inside another word

[cheweeman]

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.
Thank you for your help.

 

[Andrew Poulsom]

Welcome to Mr Excel.

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

 

[cheweeman]

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)

 

[cheweeman]

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)

My bad...
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.
Thanks for your help

 

[cheweeman]

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