formula to show a text answer

Hi everyone , i have a simple question re a formula , If i have a list of people with their score in the next coloumn next to their name eg bill 23. I know how to get in another cell the formular to show the highest score out of a group of peole but i want the answer to show the entire row or the name of the highest scorer. any help appreciated.
Paul

You can use VLOOKUP() to look up a unique value in a column of values and return another value from to the right from the same row. If you want to pull the name, too, you will need to add another copy of the "name" somewhere to the right of the name.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.