Numbers: Find highest points and output the associated name ?

Discussion in 'iPad Apps' started by LN-TAL, Oct 1, 2011.

  1. LN-TAL macrumors newbie

    Joined:
    May 26, 2011
    #1
    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 ?
     
  2. LostLogik macrumors 6502a

    Joined:
    Jul 9, 2008
    #2
    How about the vlookup function? for example, =vlookup(item searched for, range, column number to be displayed of the range searched)
     

Share This Page