With your posted data list in A1:F4

For an exact match...

Try this:
A8: (Test to use....eg 2)
A9: (value to find...eg 1.5)

This formula returns the top row score
associated with the A9 score
for the A8 test.
=INDEX(A1:F1,MATCH(A9,OFFSET(A1:F1,MATCH(A8,A2:A4, 0),),0))

NOTE: if the A9 value is not found....the formula returns an error.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Eric" wrote in message
...
I am looking for either a macro or a function that will return a certain
value.
ie: % With in Limits
test 100 99 98 97 96 .......
1 0.9 0.8 0.6 0.3 0.1
2 1.8 1.7 1.5 1.3 1.0
3 2.9 2.8 2.4 2.2 2.1

Test #2 find number 1.5 Return value 98

I hope someone can help me.
Eric