title: how to get a cell to use in a formula excel
body: <p>I am trying to get where the =LARGE formula got the figure from, so that I can then grab the cells to the right of it.</p>
  
  <p>Basically I have a list of 100 scores, with hits and golds and the persons name next to it.</p>
  
  <p>I am using =LARGE(A1:A100,1) to get the highest number, but then I am wanting to know how I can find the cell its got it from, so I can then get the 3 cells to the right of it.</p>
  
  <p>So for example, if the highest figure is in A10 say, how can I find this out from the LARGE formula?</p>
  
  <p>Thanks,</p>
  
  <p>Doomie</p>