+ Reply to Thread
Results 1 to 4 of 4

Table Lookup based on values in 5 cells

  1. #1
    Registered User
    Join Date
    01-06-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    39

    Table Lookup based on values in 5 cells

    Hi All,

    I am looking for your expertise with something.

    I have attached a test workbook with a sample of what I am trying to achieve.

    Basically the user can enter data in any one of 5 entry cells and the table below would update based on that criteria from a lookup table in a different worksheet.

    Now sometimes the user will enter 1 of those 5, other times all 5, other times 3/5, etc. So I need a dynamic lookup based on the user entry which will correspond the the Entry Column values in the Lookup sheet.

    Let me know if this makes sense.

    I am not sure as to how I would go about doing this?

    Thank you for all help!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-14-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    187

    Re: Table Lookup based on values in 5 cells

    Hi,

    Please check whether the attached file would work for you

    Regards,

    Veejar
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-06-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    39

    Re: Table Lookup based on values in 5 cells

    Hi veejar,

    I get a ref error on my Master table so now results are being displayed.

    Basically the Master sheet table needs to display the values from the lookup sheet based on the entries in the entry cells. Also, the user will not always select all of them and they need to be unique values which is why your drop downs wouldn't work.

    Sorry, it was probably due to a lack of explanation from my part.

    Thank you.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Table Lookup based on values in 5 cells

    Hi TalResha,


    I am not able to find (Supplier Utility Product Type Product Name SME or Corporate Minimum Threshold Maximum Threshold Product Definition Fixed Consumption Level) in the Lookup sheet....?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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