W
WindBarb
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?
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?