I will try to explain this the best I can.

I have to do a calcualtion.
The answer to that calculation will then be used to look up data in a table.

For Example
A B C D
6.60 13657 178.3 70.20 67.79
6.70 13886 179.9 70.16 67.68

My calculated answer was 6.67.
How do I write a formula so that excel will return the corresponding values
for A B C & D for 6.67.

I have tried but the VLOOKUP function but it keeps returning the lower
values which is not what I want.


Yours hopefully
Simon