Vlookup

[Guest]

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.

 

[tony h]

are the numbers integers or are they fractinal?

 

[Guest]

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

---