Multiple Tables

[Mtttt1900]

Hi,

i have set up multiple tables (8) that select a rate for different types of construction.  I have two drop down boxes for each table that select the rate by sq ft in rows and construction grade in columns.  Independently they work.  But what I’m trying to do is make another sheet that each line will have a drop down to choose from the 8.  But when I use index and match to pull the info, the data valuation drop downs don’t work.  I don’t get the drop down arrow to choose options.

any help would be appreciated.

[#2]

Hi @Mtttt1900 

It looks like you trying to get the data from multiple table and retrieve the information based on the matching results. You need to use indirect function to make it dynamic.

This video might be helpful : https://youtu.be/ROym3e-S4OQ

If you are still facing difficult then request you to please attached sample file of your data to provide you the solution

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more