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
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