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
---
"Ruth" wrote:
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.
--
Thank-you!
Ruth