I created a workbook that has individual sheets with 5 separate contestant
scores. The last sheet is a total page with point totals for each contestant
as a reference from their individual sheet in column 1 and the corresponding
contestant name in column 2. I am trying to use vlookup to view the data in
column 1 and return the corresponding name in column 2 in a cell of my
choosing. The total page looks like this: Please note that the values in
column A are references from calculations from other sheets.
A B
45 Brian
39 Alice
42 Tim
40 Jim
50 Ana

How can I use vlookup to show "Ana" as the winner in a cell of my choosing.

Hopefully someone can help.

Thx