PDA

View Full Version : [SOLVED] Help with authoirisation list please



blackie42
04-24-2016, 09:37 AM
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
04-24-2016, 11:26 AM
Are you saying that it will either be M1:M10, M6:M10 or M9:M10 assuming the list is in M1:M10?

blackie42
04-24-2016, 02:01 PM
Hi Xld,

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

regards
Jon

Bob Phillips
04-25-2016, 03:32 AM
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
04-25-2016, 10:29 AM
Perfect

Thanks V Much for your hekp

regards
Jon