Drop down based on multiple validation lists

**beaunydal** · 11-17-2011, 09:30 AM

If you name the lists you can use the INDIRECT function to refer to the appropriate Source.
Say the three cells with Companies 1 to 3 under the 111 heading are named...
_111Cos
and similarly for the two other Company lists...
_222Cos
_333Cos

then on the Data Validation dialogue this formula will refer to the appropriate companies depending on the value selected in B12...
=INDIRECT("_"&$B$12&"Cos")

Beau Nydal

**projectile** · 11-17-2011, 10:07 AM

Hi Beau,

thanks for the reply but the idea of the bottom list is it's suppose to be one big list of all the companies based on what is chosen in cell B12 B13 and B14

e.g. if B12 is 111 and B13 is 222 then the list should display Company 1 to company 7

see attached image hope this is clearer.

Regards