Vlookup

C

Confused?

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.
 
M

Max

Confused? said:
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.
Click to expand...

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
 
Top