hi
I have this formula to find the first value , I'm looking to tweak it to find the last matched value
=INDEX(Data!$E$2:$G$20000,MATCH(Profit!A2,Data!$G$2:$G$20000),1)
I have tried the formula below which is adding the "2,1/" but excel adds an @ symbol to the Match DATA array which breaks the formula.
=INDEX(Data!$E$2:$G$20000,MATCH(2,1/(@Data!$G$2:$G$20000=Profit!A2)),1)
I have this formula to find the first value , I'm looking to tweak it to find the last matched value
=INDEX(Data!$E$2:$G$20000,MATCH(Profit!A2,Data!$G$2:$G$20000),1)
I have tried the formula below which is adding the "2,1/" but excel adds an @ symbol to the Match DATA array which breaks the formula.
=INDEX(Data!$E$2:$G$20000,MATCH(2,1/(@Data!$G$2:$G$20000=Profit!A2)),1)