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