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.
column F =VLOOKUP($E2,$A$2:$C$12,3)
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.column F =VLOOKUP($E2,$A$2:$C$12,3) Read More
