Can someone help be understand why the data the the vlookupfunction is
returning is the value of the cell above the lookup up value. e.g
lookup value is 3
table array is:
1 A
2 B
3 C
formula result is B instead of C.

are the numbers integers or are they fractinal?


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=561648

"Confused?" wrote:
Can someone help be understand why the data the the vlookupfunction is
returning is the value of the cell above the lookup up value. e.g
lookup value is 3
table array is:
1 A
2 B
3 C
formula result is B instead of C.

One guess ..
The lookup value is a value / calculated value which is actually less than 3.
For eg in A1: 2.9999, but with A1 formatted as number to 2 dp, shows as 3.00
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---