vlookup not working properly

[Ruth]

Hi there

I set up a vlookup and it doesn't work properly.

This is the table for lookup:

Grain 0.044
Sand 0.055
Salt 0.033
Stone 0.055


Then I have a cell that you choose the product type using the first column
as a validation list

Then I have a vlookup that looks up the rate using the cell with the product
in it in the using the same table that I used for the validation list.

For some reason when one of the products, "Salt" is in the cell it does not
enter the correct value. It inserts "0.044". But it works for the other 3
products.

The formula I used is:

=VLOOKUP(D63,$K$63:$M$66,3)

I used 3 because the product column is a 2 column merge. I also tried it
where each column is just one column and placement was 2-- but had the same
problem with "Salt"

Please advise.

 

[Max]

Use an exact match, ie with the 4th param = zero (or FALSE)
=VLOOKUP(D63,$K$63:$M$66,3,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik

 

[PCLIVE]

Probably has something to do with the "Salt" column not being sorted
alphabetically.

 

[Bob Phillips]

Try putting ,FALSE at the end of the formula (you might have ,TRUE or
nothing at all)

 

[Ruth]

Thank-you very much-- I was so frustrated-- your suggestion worked perfectly.

 

[Max]

Welcome, Ruth. Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik