Forum Discussion
Solved
vlookup closet strange mismatch (just two value: 0.051 & 0.071)
I have a vlookup question. Attached is a simple worksheet. Why does Cell G7 get the value 28 when I expect the lookup result to be 30? The formula is lookup the closet match value on A2 to C12. col...
Also: try changing the formula in A3 to =ROUND(B2+0.001, 3), then fill down.
Please set both columns A and E to display 15 decimal places.
I suspect that you'll see that the value of E7 is a tiny bit smaller than the value of A7, and that the value of E9 is a tiny bit smaller than that of A9.