Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Take Value To Left Of Maximum Value In A Column

1. Member
Join Date
22nd November 2005
Location
Wollongong, Australia
Posts
33

## 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.

Excel Video Tutorials / Excel Dashboards Reports

2. Member
Join Date
22nd November 2005
Location
Wollongong, Australia
Posts
33

## 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.

Excel Video Tutorials / Excel Dashboards Reports

3. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,678

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

Try,

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

HTH

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno