vlookup not working properly

  • Thread starter Thread starter Ruth
  • Start date Start date
R

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.
 
Try putting ,FALSE at the end of the formula (you might have ,TRUE or
nothing at all)
 
Back
Top