Excel 2007 : Issue with vlookup and approximate match

Hello Excel Masters

I have Table like this (sorted in ascending order):


Column1 Column2
100% 115%
101% 116%
102% 117%
104% 118%
106% 119%
107% 120%

and I am trying to use vlookup function with approximate match for 103,2%. Logically the vlookup function should return 118% as 103% this is closer to 104% than to 102%, but I receive 117%. That's understandable after I read that:

"Excel works its way down the first column until it finds a value greater than the lookup value. Then it backs up one row to return its results."

However I would like vlookup to give me 118% for 103,2% and in other case - 117% for 102,7%, but in both cases I receive 117%.

Does anyone can help me to solve this issue? I would be really gratefull!

Ps. Column 1 contains only integer percentages

Thanks in advance,
Sylwia