Simple VLOOKUP not bringing back correct results

[AL2275]

I created a simple VLOOKUP function that gives results based on the value chosen from a list. It works for most products in the list, but some return an incorrect value. Can someone please take a look at it and provide feedback?

=VLOOKUP(F10,C3:D20,2)


I've included the excel file and a screenshot of results as attachments.

[estige]

Hi, try
=VLOOKUP(F10,C3:D20,2,0)

[martindwilson]

correct vlookup syntax is to add true or false not 0 or 1
=VLOOKUP(F10,C3:D20,2,false) will look for an exact match
from vlookup help

Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.

[estige]

Ok, thanks for the correction. I thought it didn't matter if one uses 0 or FALSE.

[Cutter]

I don't think it does.

[martindwilson]

it doesn't but its what the help file shows!
so imo for a new user its best to follow that.
because the next question should be
"why 0?,i cant see that explained anywhere"
then you would have to explain that in excel 0 can =false and 1= true

[AL2275]

Adding False to the statement corrected my issue. Thanks for the responses.