Hi guys,
I am trying to get the name of a person who scored the maximum in a game. I have used vlookup before, but from what I can see index and match are a more powerful tools because they works vertically as well.
As you can see from the spreadsheet that I have attached, I have given it a go in I6.
If you solve my problem can you please explain in detail how you do it? On YouTube the videos show examples without actually explaining the exact meaning of the functions, so I think I am a bit lost.
Best Regards,
Tsvetan
Bookmarks