+ Reply to Thread
Results 1 to 6 of 6

Lookup Formula for multiple cells with multiple results

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    24

    Lookup Formula for multiple cells with multiple results

    If E16 is Male and H16 is over 18 but under 30 then insert whatever number is in R6
    However if E16 is Male and H16 is over 30 but under 40 then insert whatever number is in R11
    However is E16 is Female and H16 is over 18 but under 30 then insert whatever number is in R31
    However is E16 is Female and H16 is over 30 but under 40 then insert whatever number is in R36
    There’s about 6 other variations but if you could please write out the entire code covering all 4 variations above I can take it from there. THANK U!!!
    Last edited by CKD777; 10-15-2011 at 12:26 AM. Reason: solved

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Lookup Formula for multiple cells with multiple results

    Maybe this series of IF statements:

    Please Login or Register  to view this content.
    Just as a heads-up, I added an equal sign before 30 so that it is caught in one of the categories.

    Hope this helps.

    abousetta
    Last edited by abousetta; 10-14-2011 at 11:26 PM. Reason: Corrected the syntax... again
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,257

    Re: Lookup Formula for multiple cells with multiple results

    Hi CKD777

    I think you should look at the Vlookup function with a TRUE for the last argument. See
    http://www.excelfunctions.net/ExcelVlookup.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Lookup Formula for multiple cells with multiple results

    I noticed some mistakes in the formula I posted. I have corrected them. Just thought I would let you know to discard the earlier formula.

    abousetta

  5. #5
    Registered User
    Join Date
    10-14-2011
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Lookup Formula for multiple cells with multiple results

    Quote Originally Posted by abousetta View Post
    Maybe this series of IF statements:

    Please Login or Register  to view this content.
    Just as a heads-up, I added an equal sign before 30 so that it is caught in one of the categories.

    Hope this helps.

    abousetta
    Thanx for the effort. Still didn't work, but I appreciate you trying to help
    Last edited by CKD777; 10-15-2011 at 12:25 AM. Reason: Solved

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,257

    Re: Lookup Formula for multiple cells with multiple results

    If you attach a sample workbook it is much easier to solve this problem.

    Click on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area to attach a file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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