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! :-)
Bookmarks