Validation list in a conditional formula

I would like to include a validation list (drop down choices) in a
conditional formula in Excel.

Something along the lines of

=IF(A4="RAIN",$B$11,IF(A4="TEMPERATURE",$D$11,""))

where $B$11 has a drop down choice of appropriate units for rain based
on a list from a column of cells (e.g. containing inches, cm, mm) and
$D$11 has a drop down choice of appropriate units for temperature
based on a different list from a different column of cells
(e.g.containing Kelvin,Centigrade,Fahrenheit).

But I can't get the validation list with the drop down choices to be
used in the conditional formula.

Also, my actual choices of weather parameters in cell A4 is up to over
50, so I don't think I can have that many embedded IF clauses.

Can someone tell me if there's a way to do this?

Peo
Wed Jul 11 18:03:28 CDT 2007

Maybe this can be adapted to your needs

http://www.contextures.com/xlDataVal02.html


--
Regards,

Peo Sjoblom





"WindBarb" <sauter@zianet.com> wrote in message
news:1184194353.356734.88070@22g2000hsm.googlegroups.com...
>I would like to include a validation list (drop down choices) in a
> conditional formula in Excel.
>
> Something along the lines of
>
> =IF(A4="RAIN",$B$11,IF(A4="TEMPERATURE",$D$11,""))
>
> where $B$11 has a drop down choice of appropriate units for rain based
> on a list from a column of cells (e.g. containing inches, cm, mm) and
> $D$11 has a drop down choice of appropriate units for temperature
> based on a different list from a different column of cells
> (e.g.containing Kelvin,Centigrade,Fahrenheit).
>
> But I can't get the validation list with the drop down choices to be
> used in the conditional formula.
>
> Also, my actual choices of weather parameters in cell A4 is up to over
> 50, so I don't think I can have that many embedded IF clauses.
>
> Can someone tell me if there's a way to do this?
>

WindBarb
Thu Jul 12 10:18:59 CDT 2007

That worked perfectly. Thank you very much for the prompt assistance.