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!
Bookmarks