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.
Also: try changing the formula in A3 to =ROUND(B2+0.001, 3), then fill down.
Thank you, you saved my life. round function is work.