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

​