Drop Down List to fill table from multiple tables

**hidden78731** · 05-08-2012, 11:25 AM

This is a hard one for me to put into words.

I would like to be able to fill a Table that shows a variance of rates over 3 years, by referencing different tables from separate tabs. So, for instance, the drop down list would say, "Choice 1", "Choice 2", etc. - all the way to "Choice 5".

When you choose one of those options it would show rate variance from that Choice of the 3 years (see attached).

I really appreciate any help on this, thank you.
-H

UPDATED: There are notes and a more clear explanation in the attached workbook (thank you for your feedback).

UPDATED AGAIN: I put the wrong version in again - please excuse my mistake.

**shekhar1660** · 05-09-2012, 09:55 AM

Hi,

Would be helpful if you can specify where you would like to have drop downs (validation) and which data you want to pickup with drop down?

**Jop_4444** · 05-10-2012, 12:12 PM

I think he wants to know how to set the drop down to change the information table

like:
Select choice1 - displays information table1
Select choice2 - displays information table2 (Replacing information table1 with information table2)
and so on

I would like to know the same!