+ Reply to Thread
Results 1 to 2 of 2

How To Use The VLOOKUP, MAX, SUM Function?

  1. #1
    Registered User
    Join Date
    09-08-2007
    Posts
    10

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

    Thank You In Advance
    _____________
    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.
    Last edited by Richard Buttrey; 06-26-2008 at 07:01 PM. Reason: Reminder about attaching workbooks rather than .jpg pictures

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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