I have 2 drop downs (one dependent on the other) and I need the next set of cells in the row to retrieve data based on the second drop down from the table called by the first drop down.
I tried VLOOKUP but the data is retrieved from multiple tables and only filtered by the drop downs.
The file is attached, any help would be great, this has been keeping me up at night.CheatSheetMultiTable.xlsx
Try this for unit:And this for cost:Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Worked perfectly!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks