populate from drop list with multiple tables

[price83]

Hi All,

i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on another sheet that relate to the selected drop... is this possible?

 

[Fluff]

What do you get with the formula in post#19?

 

[price83]

#REF!

 

[Fluff]

In that case the value is B1 is not the same as the name of one of your tables.
The values in B1 must exactly match the name of a table.

 

[price83]

In that case the value is B1 is not the same as the name of one of your tables.
The values in B1 must exactly match the name of a table.

i am at a loss then didnt realise t would be so complicated to just display a comment from a different table for each company

 

[Fluff]

It's not complicated, if you change the table names to reflect the values in B1, or change the values in B1 to reflect your table names.
Another option is to create a list with the values in B1 in one column & the relevant table name in the next column, you could use Vlookup.

 

[price83]

it could be working now but it says #spill! any ideas

 

[Fluff]

That makes it even easier, as you have the new dynamic array functions.
If you want the list to start in E2, make sure all the cells below are empty & use
=INDEX(INDIRECT($B$1),0)
This will automatically spill down as far as needed.

 

[price83]

still showing even after ive changed it

 

[Fluff]

Did you delete the contents of the cells below where you entered the formula?

 

[price83]

yes, but when i enter the formula it populates all the rows underneath