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

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

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


--

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

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

--
__________________________________
HTH

Bob

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

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


"Max" wrote:

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

Welcome, Ruth. Glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik
---
"Ruth" wrote in message
...
Thank-you very much-- I was so frustrated-- your suggestion worked
perfectly.
--
Thank-you!
Ruth