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.
It is due to rounding most likely as the data in col.E might not be exactly as in col.A
Your can easily formulate a check to see if they match if the following is TRUE =A7=E7
Your can easily formulate a check to see if they match if the following is TRUE =A7=E7
thank you for your reply, yes it is strange rounding issue. even though =A7=E7 is return true, the mismatch error can be rectified follow HansVogelaar rounding suggestion.