Announcement

Collapse
No announcement yet.

Take Value To Left Of Maximum Value In A Column

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Take Value To Left Of Maximum Value In A Column

    Trying to grab the value to the left of the max value in a range of cells.

    Wasn't sure if I needed to use the offset function, I tried the vlookup function but the value i'm searching for is in the 2nd column, not the first.

    I can't download files at work, so if you could examine the example spreadsheet i uploaded, and then type the formula I should use in the post, that would be highly appreciated.
    Attached Files

  • #2
    Re: Take Value To Left Of Maximum Value In A Column

    I think i solved it, but I'd like to make sure that the function I'm using would be the most desirable...

    =OFFSET(B7,MATCH(MAX(C7:C52),C8:C52,0),0)

    The references are different to the example I posted, simply because I was working off my main spreadsheet... it pulls up the desired location, is this solved?

    Thanks for any insight.

    Comment


    • #3
      Re: Take Value To Left Of Maximum Value In A Column

      Try,

      =INDEX(B2:B13,MATCH(MAX(C2:C13),C2:C13,0))

      HTH
      Kris

      ExcelFox

      Comment

      Working...
      X