Try this:

Assume the table is in the range A1:C9

E1 = criteria 1 = .05
F1 = criteria 2 = 7

Formula entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(C1:C9,MATCH(1,(A1:A9=MAX(IF(A1:A9<=E1,A1:A9 )))*(B1:B9=MAX(IF(B1:B9<=F1,B1:B9))),0))

Biff

wrote in message
oups.com...
You're right. I meant for my first example to have a criteria of .05,
not .5. But I did not type what I was thinking.

Sorry for the confusion.