dropdown list within IF statement?
 

I'd like a dropdown list to apper when criterion isn't met. For example:
=IF(J1="","",dropdown list using a list called =Options)
Because I don't want a drop down list in every cell in the column, and it
would take too long to do it manually, can this be done?
--
Traa Dy Liooar

Jock

dropdown list within IF statement?
 

Hi,

Functions return values to the spreadsheet they do not return list, or take
actions. You can return the list called Options to the IF function but it
will not be a drop down list.

To do this you would need to write VBA.
--
Cheers,
Shane Devenshire


"Jock" wrote:

I'd like a dropdown list to apper when criterion isn't met. For example:
=IF(J1="","",dropdown list using a list called =Options)
Because I don't want a drop down list in every cell in the column, and it
would take too long to do it manually, can this be done?
--
Traa Dy Liooar

Jock