+ Reply to Thread
Results 1 to 2 of 2

Need to return value based on multiple cells

Hybrid View

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    4

    Need to return value based on multiple cells

    So essentially I have a worksheet with multiple tabs used for allocating items to different locations. I want to create a summary sheet that returns data if that cell is under several different headings. I would like the summary sheet to look through the rest of the document for the description, then the style, then the size, then return a value next to it. So for example, cell C2 in Example 1 should find the descrption "Basic Cotton Tee," then "Style 1," then size "S," then finally bring back the correct value, in this case it would be 3. Hopefully I'm explaining this well. I'm not sure how to coordinate the VLOOKUPs and HLOOKUPs or INDEX functions correctly here. Thank you!
    Example 1.xlsx Example 2.xlsx

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

    Re: Need to return value based on multiple cells

    Hello and welcome.
    You did not give the "full picture" - a worksheet with multiple tabs.
    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

+ 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. vlookup to return multiple cells based on month
    By ashwin272012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2013, 10:57 AM
  2. Replies: 7
    Last Post: 09-06-2013, 11:59 PM
  3. [SOLVED] Formula to return specific text based on multiple cells meeting a single criteria
    By missydanni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2013, 09:48 AM
  4. [SOLVED] return multiple results from one column based on cells in another column
    By chollyfunk in forum Excel General
    Replies: 5
    Last Post: 05-09-2012, 05:20 AM
  5. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 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