formula to return the Oldest year in which the amount was found

[munaaba]

Dear Excel Forum Users,

I need a formula to return the Oldest year in which the amount(Column H) was found

regards
Munaaba

[Fluff13]

How about

Please Login or Register  to view this content.

[popipipo]

Please Login or Register  to view this content.

Try this formula after converting the years in column C into numbers.
It is now text.

[CARACALLA]

I4=IFERROR(INDEX($C$4:$C$25,MATCH(G4&H4,INDEX($B$4:$B$25&$D$4:$D$25,),0)),"")

Copy down

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread, where you had a response from me and one other yesterday: https://www.excelforum.com/excel-new...that-code.html