Google sheets: IF Function from another tab, most recent populated cells

Hi all,

Please see my sheet here:

https://docs.google.com/spreadsheets...it?usp=sharing

On the tab: leaderboard v4, cell F2, i am trying to setup an IF function to take the last populated cells with a value of 20 ("Pts" i.e. cells U7, AA7 and so on) from the tab Fixtures/Selections v4 and returning cells: Q5, W5 and so on. So basically the names of who scored 20 points.

*UPDATE* Unsure if an INDEX and MATCH function can work judging by research I am reading?

Any help appreciated!!

thank you! :-)

Is this really any different to your previous thread?

https://www.excelforum.com/for-other...ml#post5179142

Hi Ali,

Yes these are different requests. The only similarity is the fact I am wanting the 'last populated' cells and the 2nd request relies upon a IF Function (whereas I don't think the one does..)

Thank you.

OK - thanks.