Vlookup Glitch in Excel '97?

[Greg]

I have Excel '97 and may have found a glitch. I have 2
worksheets in a file as follows:

Sheet 1 (columns = A,B,C with values as numbers):
A B C
0 10 0 to 10
10.1 20 10 to 20
20.1 30 20 to 30
30.1 35 30 to 35
35.1 40 35 to 40

Sheet 2 (Columns A & B with value in A as %)
A B
30.1% 20 to 30

I have the following formula in B1 of Sheet2:
=VLOOKUP(A1*100,Sheet1!$A$1:$C$5,3,TRUE)

As you can see the formula brings back '20 to 30' instead
of '30 to 35'. It brought back the correct value when
using 10.1 and 20.1 for the value in A1, but not for 30.1
or 35.1.

Any thoughts?

Thx

 

[Frank Kabel]

Hi Greg
try
=VLOOKUP(ROUND(A1*100,1),Sheet1!$A$1:$C$5,3,TRUE)

 

[Guest]

That did the trick!

Thanks!

-----Original Message-----
Hi Greg
try
=VLOOKUP(ROUND(A1*100,1),Sheet1!$A$1:$C$5,3,TRUE)


--
Regards
Frank Kabel
Frankfurt, Germany


.