"Dynamic" List creation

Hi all,

I am trying to create a drop-down list for a cell whose values displayed are dependant upon other cell values in the same worksheet.

Basically I have created a number of worklists (in another worksheet) and then reference one of those lists dependant upon a numeric value in another cell of the current worksheet.

The trouble is when I try to define the code to do this, (basically a very ugly =IF(E17<175000;AppGrp1;IF(E17<340000;AppGrp2;....etc. )))))

It doesn't fit into the Source field set up for this drop down list. Is there another way of implementing this type of functionality?

Thanks in advance

Anthony

First, set up the following two-column table...

0 AppGrp1
175000 AppGrp2
340000 AppGrp3
etc.

Secondly, define a name for the table, for example Table. Then use the following formula as your 'Source'...

=INDIRECT(VLOOKUP($E$17,Table,2))

Hope this helps!

Originally Posted by Antmeister

Hi all,

I am trying to create a drop-down list for a cell whose values displayed are dependant upon other cell values in the same worksheet.

Basically I have created a number of worklists (in another worksheet) and then reference one of those lists dependant upon a numeric value in another cell of the current worksheet.

The trouble is when I try to define the code to do this, (basically a very ugly =IF(E17<175000;AppGrp1;IF(E17<340000;AppGrp2;....etc. )))))

It doesn't fit into the Source field set up for this drop down list. Is there another way of implementing this type of functionality?

Thanks in advance

Anthony

Thanks, that worked a treat!