Data validation in if statement

Hi...

I am trying to put value from data validation into if statement
e.g. if the data validation is "Jan", then formula like: =IF(Jan!11="","",Jan!F11), if i the data validation is "Feb" then the formula become like: =IF(Feb!F11="","",Feb!F11)
so I can run it like a normal IF statement, is there a way?

Thanks for your time...

Data Validation is a way of restricting the selection of a value by various means. One of the simplest is a Drop Down Validation List.

The value you pick from the DV List will be in a cell. So you can use that cell in your formula.

If the DV List is on cell A2, the formula would be:

=IF(A2="Jan",...,...)

Or am I missing the gist of what you are asking?

Regards

Sounds like you want INDIRECT but be aware it's Volatile (see link in sig. for more info.)

=IF(INDIRECT("'"&$A$2&"'!F11")="","",INDIRECT("'"&$A$2&"'!F11"))

where A2 holds DV cell.

you can make the cell references in the INDIRECT dynamic by all manner of means but to illustrate we'd need a better understanding of where you are using the above (in terms of fill range and associated precedent range)