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]

Isn't that what you want?

 

[price83]

sorry yes but i mean it fills with the error

 

[Fluff]

What is the error?

 

[price83]

#spill!

 

[Fluff]

When you get that error, it means that the formula cannot "Spill" far enough because there are one or more cells in the spill range that contain a value or formula.

 

[Fluff]

Are you trying to put the formula in more than cell? If so, don't Xl will do it for you.

 

[price83]

ok it is now working, however...

this has now stopping another column from working as this column used the indirect formula to create an average score from another column in the table

 

[Fluff]

Back in post#14 I asked

Also is the table just one column?

And you said "Yes".
Are you now saying that the tables are more than 1 column?

 

[price83]

my apologies i thought you meant just for the first amount of data

 

[Fluff]

In that case can you post some sample data showing exactly how both sheets are laid out.