title: Using VLOOKUP to return information based on the maximum value in a range
body: <p>I am trying to use vlookup to return information based on the maximum value of a cell within a range.</p>
  
  <p>I have a table in which each row is a sports team and each column is a weekly points total.</p>
  
  <p>I have 2 cells that show the highest points scored in the current week and the name of the team that scored them.
  The team name is generated by the formula 
  =VLOOKUP(MAX(Admin!G3:G16),Admin!G3:K16, 5, FALSE)
  This works fine.</p>
  
  <p>I also wish to have 2 cells that show the highest weekly points total ever achieved, along with the name of the relevant team.
  However, I can not amend the above formula to work on a range instead of a row, and no matter what I do, it always returns an #N/A result for the team name.
  The most logical formula I tried is
  =VLOOKUP(MAX(Admin!N18:BE31),Admin!N18:BG31, 47, FALSE)</p>
  
  <p>where columns N through BE are the weekly scores (which are generated by a formula, if that makes a difference?) and column BG contains the team names.</p>
  
  <p>Maybe this function isn't designed to work on a range in the same way as a column, maybe I have made an error in the formula, or maybe there is another better way to retrieve the information?</p>
  
  <p>I just can't work it out, so am sincerely hoping somebody can point me in the right direction. 
  Many thanks for any assistance.</p>