u/Sew_Link

Hello ! Hope you're all good !

I try to use the "VLOOKUP" function (alias "recherchev", i work in french for the moment) to show the name of the 1st and 2nd person who have most points of the "POULE 1". In this case, "Participant 25" and "Participant 26".
But it does'nt work and it's the last thing i have to do... what am i supposed to put in the first fonction ?

https://preview.redd.it/nnqgp12gbgbh1.png?width=1019&format=png&auto=webp&s=44e77b4be3d1917be2e0322e48514341d353bf80

https://preview.redd.it/ecad8dwgbgbh1.png?width=859&format=png&auto=webp&s=62142381f6781677225f69e95e7d1169e08b863e

https://preview.redd.it/3wtz5g7ibgbh1.png?width=1196&format=png&auto=webp&s=bb95c37b0189bf89e542a28c6797b4d2f0e0b3ab

I work in the 2016 version on Windows 11. I'm a beginner so i still have some difficulties ^^'
Note : Faux = false in french

Thanks in advance !!