VLOOKP does not find values and shows 0

[tamassafrany]

Hi,

I want to refresh stock values with VLOOKUP but it does not find any value and shows 0. Please check in C2.

What should I change in the function?

Thank you
Tamas

[Sam Capricci]

I think you should add false to your equation, like... =VLOOKUP(B2,$G$1:$H$7417,2,FALSE)
otherwise I believe it is defaulting to true which will look for approximate matches instead of exact matches.

[Sam Capricci]

it will return #N/A for no matches so you might want to add something like an IFERROR to handle the #N/As
like =IFERROR(VLOOKUP(B2,$G$1:$H$7417,2,FALSE),"") or =IFERROR(VLOOKUP(B2,$G$1:$H$7417,2,FALSE),"not found")

[davsth]

is =VLOOKUP(B2,$G$1:$H$7417,2,0) any closer. You have not put the last parameter in for an exact match

[alansidman]

Your formula was incomplete

=VLOOKUP(B2,$G$1:$H$7417,2,FALSE) and copy down