dropdown list within IF statement?

J

Jock

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

ShaneDevenshire

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