Help with authoirisation list please

[blackie42]

Hi,

I have a dropdown list in cell A1 where 10 people from a data validation list can be selected.

I have another dropdown list in B1 where I would like certain conditions to apply based on the value in cell C1...

If the amount in cell C1 is less than or equal to £500 the all people in list can be selected

If the amount in cell C1 is >£500 but less than or equal to £1000 then only the last 5 in the list can be selected

If the amount in cell C1 is £1000+ the only the last 2 people in the list can be selected

Or do I need to use 3 lists and link these to the value?


Ant ideas how I can achieve something like this?

many thanks
Jon

[Bob Phillips]

Are you saying that it will either be M1:M10, M6:M10 or M9:M10 assuming the list is in M1:M10?

[blackie42]

Hi Xld,

Yes that would be right - the list shortens as the value increases

regards
Jon

[Bob Phillips]

Then just create a DV, type List, with a formula of

=IF($C$1>1000,M9:M10,IF($C$1>500,M6:M10,M1:M10))

[blackie42]

Perfect

Thanks V Much for your hekp

regards
Jon