Data validation in if statement

**mahoo** · 02-15-2011, 04:20 AM

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

**TMS** · 02-15-2011, 04:25 AM

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

**DonkeyOte** · 02-15-2011, 04:34 AM

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

Please Login or Register  to view this content.

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)

**mahoo** · 02-15-2011, 04:06 PM

Originally Posted by DonkeyOte

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

Please Login or Register  to view this content.

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)

worked like a charm. Thanks