+ Reply to Thread
Results 1 to 5 of 5

Lookup multiple cells to return data

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Lookup multiple cells to return data

    Hi

    Attached is a spreadsheet that I am working on, on the 3050x2030 tab is the data I have imported. I am looking at getting sheet 1 to look at this data and return the correct figures. If you look at cell C25 this returns the correct data. But I then can't figure out how to get the data for the used and weight cells C26 and C27 which is columns E and F on the 3050x2030 tab. I also can't get the formula to work when replicated for other thicknesses see cell C31. I am trying to get a result based on looking up 4 cells Date, shift, thickness and then (either qty,used or weight)

    Am I going about this completely the wrong way or am I making a simple mistake?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Lookup multiple cells to return data

    There's something I don't understand -

    If I edit C25 which now says 314, (by, say, changing the $D$400 to $F$400) I get an Oops. OK, maybe that's right. If I edit it back to $D$400 I still get Oops. Huh?
    If I perform Undo, however, returning it to $D$400 I once again get 314.

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Lookup multiple cells to return data

    Thanks everyone for looking I managed to sort it eventually. I think I set myself too big a challenge sometime, just to save a few minutes a day ( but they all add up)

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Lookup multiple cells to return data

    Unmarge your cells in column B and add values for each cell(mergin is very bad habit)
    Then in C13
    =IFERROR(INDEX('3050x2030'!$D$2:$F$400,MATCH($C$1&$C$2&$B13,'3050x2030'!$A$2:$A$400&'3050x2030'!$B$2:$B$400&'3050x2030'!$C$2:$C$48,0),MATCH($A13,'3050x2030'!$D$1:$F$1,0)),"Ooops")
    Drag down

    In C53 drag down
    =SUMIF($A$13:$A$51,$A52,C$14:C$52)
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Lookup multiple cells to return data

    Pl see the attached file.
    Formula used in C22 isbelow. Same is pasted other area.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP to return multiple cells of same lookup value
    By gerardog92 in forum Excel General
    Replies: 6
    Last Post: 01-24-2014, 03:35 AM
  2. VLOOKUP to return multiple cells of same lookup value
    By gerardog92 in forum Excel General
    Replies: 2
    Last Post: 04-26-2012, 02:19 PM
  3. Replies: 7
    Last Post: 05-15-2011, 07:06 PM
  4. Replies: 4
    Last Post: 07-07-2010, 12:36 AM
  5. lookup to return multiple cells
    By stork22 in forum Excel General
    Replies: 1
    Last Post: 10-29-2009, 02:46 PM

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