# How To Use The VLOOKUP, MAX, SUM Function?

1. ## How To Use The VLOOKUP, MAX, SUM Function?

Hello Fellow Members,

I' am trying to figure out how to use the VLOOKUP, MAX, SUM Function together in a formula. Here is what I' am trying to do...

for some reason it wont let me post a image but here is a direct link to it:
http://i4.photobucket.com/albums/y14...hx99/excel.jpg

as you can see there are numbers in cells: C5:E13 AND G5:G13

What I want to do is find the highest number in the cells C5:E13 and SUM it with the number that is in the same ROW of G5:G13.

EXSAMPLE:

let's say the hightest number is in cell D7, I would want to ADD cell D7 with G7

here is a other one

let's say the hightest number is in cell E12, I would want to ADD cell E12 with G12

and one more

let's say the hightest number is in cell C9, I would want to ADD cell C9 with G9

and the formula will go in cell M5.

That's basically what i am trying to do, I hope I'm explaning myself right..

_____________
Post moved from Excel programming - Richard Buttrey

Please also note the forum rule which asks you to attach actual workbook files rather than mere pictures. You can't expect those who want to help, to re-type your data.

2. Hi

Horribly awkward but try

=MAX(C5:E13)+IF(ISNUMBER(MATCH(MAX(C5:E13),C5:C13,0)),INDEX(G5:G13,MATCH(MAX(C5:E13),C5:C13,0)),IF(ISNUMBER(MATCH(MAX(C5:E13),D5:D13,0)),INDEX(G5:G13,MATCH(MAX(C5:E13),D5:D13,0),IF(ISNUMBER(MATCH(MAX(C5:E13),E5:E15,0)),INDEX(G5:G13,MATCH(MAX(C5:E13),G5:G13,0))))))

rylo

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1