Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

LN-TAL

macrumors newbie
Original poster
May 26, 2011
6
0
Hi there.

I'm trying to make a spreadsheet in numbers on my iPad. The main sheet is on sheet 2, and on sheet 1 is a summary sheet.

On sheet two I have some names in column A, and points in column B. Have a look below:

Trine 56
Niclas 34
Thomas 75

On sheet 1 (the "summary sheet") I want to display the highest score, AND it's associated name. Find the highest score is easy, I just use the maksa (in Norwegian, it's called max in excel) function, and it finds the highest score, and outputs it's. but how do I find it's associated name in column A, and outputs this name to a cell on sheet 1 ?
 
How about the vlookup function? for example, =vlookup(item searched for, range, column number to be displayed of the range searched)
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.