Formula - Value of the oldest item

[Neil07979]

Hi All

I have a spreadsheet that contains 2 columns, 1: Value, 2: Age.

I need to get a formula to give me the Value of the oldest item, but the value has to be greater than 50000.

So if I have the following:

Age - Value

1day - 30000
5days - 60000
10days - 45000

The answer I want to be returned is 60000 (This is the oldest Item with a value of Greater than 50000)

Any ideas would be appreciated.

[daddylonglegs]

Assuming age is just shown as a number (representing age in days) in A2:A100 and value in B2:B100

=MAX((A2:A100=MAX(IF(B2:B100>=50000,A2:A100)))*( B2:B100))

confirmed with CTRL+SHIFT+ENTER