software

Cannot understand why I am getting peculiar results with a vlookup query
on a table similar to one below. Using the formula
=VLOOKUP(D1,A1:B7,2)
where D1 is a drop down list created from the first column below and
A1:Bamp; is the range below as example.
eg when D1 is Sylvinite I get value 132, same with Sulphate of potash
0.60.60 gives #N/A
The rest if selected give the correct return.
I would value any help.Sylvinite 42
Sulphate of potash105
0.0.60 126
0.14.42 136
0.16.16 88
0.24.14 111
0.24.24 132

Try adding the FALSE segment to your formula........

=VLOOKUP(D1,A1:B7,2,FALSE)

Vaya con Dios,
Chuck, CABGx3
quot;Graham Haughsquot; wrote:

gt; Cannot understand why I am getting peculiar results with a vlookup query
gt; on a table similar to one below. Using the formula
gt; =VLOOKUP(D1,A1:B7,2)
gt; where D1 is a drop down list created from the first column below and
gt; A1:Bamp; is the range below as example.
gt; eg when D1 is Sylvinite I get value 132, same with Sulphate of potash
gt; 0.60.60 gives #N/A
gt; The rest if selected give the correct return.
gt; I would value any help.
gt;
gt;
gt; Sylvinite 42
gt; Sulphate of potash105
gt; 0.0.60 126
gt; 0.14.42 136
gt; 0.16.16 88
gt; 0.24.14 111
gt; 0.24.24 132
gt;

Almost too embarrased to say thanks CLR, but thank you.

Graham

CLR wrote:
gt; Try adding the FALSE segment to your formula........
gt;
gt; =VLOOKUP(D1,A1:B7,2,FALSE)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Graham Haughsquot; wrote:
gt;
gt;
gt;gt;Cannot understand why I am getting peculiar results with a vlookup query
gt;gt;on a table similar to one below. Using the formula
gt;gt;=VLOOKUP(D1,A1:B7,2)
gt;gt; where D1 is a drop down list created from the first column below and
gt;gt;A1:Bamp; is the range below as example.
gt;gt;eg when D1 is Sylvinite I get value 132, same with Sulphate of potash
gt;gt;0.60.60 gives #N/A
gt;gt;The rest if selected give the correct return.
gt;gt;I would value any help.
gt;gt;
gt;gt;
gt;gt;Sylvinite 42
gt;gt;Sulphate of potash105
gt;gt;0.0.60 126
gt;gt;0.14.42 136
gt;gt;0.16.16 88
gt;gt;0.24.14 111
gt;gt;0.24.24 132
gt;gt;

It's been said: quot;One who asks a question is a fool for 5 minutes, while one
who doesn't is a fool foreverquot;............you're very welcome for the
assistance, and any quot;Thanksquot; is always appreciated, especially one as
heart-felt as yours........be welcome to come back anytime you want to.....

Vaya con Dios,
Chuck, CABGx3

quot;Graham Haughsquot; wrote:

gt; Almost too embarrased to say thanks CLR, but thank you.
gt;
gt; Graham
gt;
gt; CLR wrote:
gt; gt; Try adding the FALSE segment to your formula........
gt; gt;
gt; gt; =VLOOKUP(D1,A1:B7,2,FALSE)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Graham Haughsquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;Cannot understand why I am getting peculiar results with a vlookup query
gt; gt;gt;on a table similar to one below. Using the formula
gt; gt;gt;=VLOOKUP(D1,A1:B7,2)
gt; gt;gt; where D1 is a drop down list created from the first column below and
gt; gt;gt;A1:Bamp; is the range below as example.
gt; gt;gt;eg when D1 is Sylvinite I get value 132, same with Sulphate of potash
gt; gt;gt;0.60.60 gives #N/A
gt; gt;gt;The rest if selected give the correct return.
gt; gt;gt;I would value any help.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;Sylvinite 42
gt; gt;gt;Sulphate of potash105
gt; gt;gt;0.0.60 126
gt; gt;gt;0.14.42 136
gt; gt;gt;0.16.16 88
gt; gt;gt;0.24.14 111
gt; gt;gt;0.24.24 132
gt; gt;gt;
gt;