Vlookup display as n/a

[Chris1973]

Hi Guys.

Can you please give me some advise on what may be wrong.

I am using v lookup with no problems.
All of a sudden when i create a new article number in the lookup file, and then enter that number in my quote does it display as N/A
All numbers are displayed correctly, the formula allows to look for the new lines being entered, i made sure enough lines are covered
If i enter the same number as previous numbers in that line does it doe the lookup, just the new numbers that i create that does not work

 

[Chris1973]

Simple question, when saying containing the id do you mean the article number, 9500500455 or the description surface brush

 

[Joe4]

Yes, 9500500455 is the ID. That is the value you are matching on.
That is the only thing we are concerned with here, the IDs in the two lists that we are matching on.
We need to compare "apples-to-apples" and "oranges-to-oranges" (right now you are comparing "apples-to-oranges", as you are comparing "text-to-numbers", which won't work for the reasons I explained).

 

[Chris1973]

Joe thanks for all your help. Everything is sorted and back to normal

Thanks so much for all the help

 

[Joe4]

You are welcome.
Glad we were able to get it working.