dropdown list within IF statement?

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

 

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