List data with IF statement

[uttamsaxena]

Hi,

I want to write an If formula with following type--

=If(condition,"",fill the cell with drop down list)

That is if the criteria is met cell is blank otherwise cell is filled with a drop down list through data validation.


Please suggest.

Regards,

Uttam

 

[Gerald Higgins]

Uttam - set up your data validation, referring to a range which contains your data. Then you can insert formulas in your source data range that show as blank if the criteria is met, and show the options if it is not met.