Forum Discussion
How to switch between tables using a dropdown
I just noticed your example table in your first post. Was that there the first time you posted it? If so, I didn't see it.
Here it is returned to you in with a formula (and table of tables) that does what you want. There no doubt are other solutions, but take a look at this and see if you can adapt what I've done.
I'd give a more complete explanation if I had time, but I'm needing to leave for a drive shortly. Come back with questions if I can help further.
This looks quite different from what I expected. I was expecting two or three tables that needed to be referenced, depending on country or some other location specific. This looks FAR different from that.
So help me navigate/understand a bit more
Note that each tab refers to a customer, noted, but what, then, is the difference between AAA/ CMH-003 and AAA/EW-001 and so on. I see different Base Rents in some of the arrays WITHIN the tab AAA.
Note that each tab refers to a customer, and that every single orange table (pricing) is identical to another -- only Customer and Location are changing at the header, I suppose that's where our formula gets in.
So help me see where that "identical to another" comes in. Which ones are identical to which other ones? What is the core identifier, then, of those that follow a given pattern or sameness.
For example, in my example of the three income tax tables, there are only three tables, even though there are five filing statuses
So i use a VLOOKUP to get, from this table, the name of the relevant table for each filing status. I did this after realizing (from the IRS's publications) that the tax table used for Married Filing Joint is in fact the same as the one for Surviving Spouses; similarly Married Filing Separate uses the same table as Single.
What are the basic tables in yours, and what in your detailed sheets calls out the one table that is applicable to it?
I just noticed your example table in your first post. Was that there the first time you posted it? If so, I didn't see it.
Here it is returned to you in with a formula (and table of tables) that does what you want. There no doubt are other solutions, but take a look at this and see if you can adapt what I've done.
I'd give a more complete explanation if I had time, but I'm needing to leave for a drive shortly. Come back with questions if I can help further.
- mathetes
Can't thank you enough for your attentiveness and thoughtfulness! I was able to reproduce the INDEX formula on my previous table, and that's fine now.
I've studied this INDEX formula once, but it was not clear to me how to use it in this example. Besides teaching me and spreading the word of the Holy Excel, your assistance is helping me deliver a major task to my directors.
That was really brilliant! Thank you again 🙂
