INEX and MATCH reverse order

[Tmian]

Hi all.
I’m Using Excel 2007
I was wondering if I could reverse the following formula.

=INDEX(Sheet1!$E$2:$E$4000,MATCH(J41,Sheet1!$F$2:$F$4000,FALSE),1)

I have two columns: Date and Description. The dates run oldest to newest.
I want to get the date from column E next to a description in column F when it equals Payday (J41)

It works a treat but it’s finding the first occurrence of Payday and returning that date. I want it to find the last occurrence of Payday and return the relative date.

Any help would be greatly appreciated.

Jase

[daddylonglegs]

Hello Jase, try this

=LOOKUP(2,1/(Sheet1!$F$2:$F$4000=J41),Sheet1!$E$2:$E$4000)

[Tmian]

Thank you very very much.

I'll try and figure out how this works now.

Take care,

Jase

[axs83m]

Hello Jase, try this

=LOOKUP(2,1/(Sheet1!$F$2:$F$4000=J41),Sheet1!$E$2:$E$4000)

Pure genius! Man!