interesting dilema

[jmorgs]

Does anybody know if I can have a dropdown list AND a IF function in th
same cell? In other words, in cell C3 have a dropdown list which i
dependent on what is picked in cell C2, but other items ar
automatically populated in cell C3 if certain things are picked in cel
C2. In other words, if you pick human factors in cell C2 a dropdow
list comes up in cell C3 and you have three choices in that list. BUT
if you pick sensors, automatically the word chemcial is put in cell C3
Is this at all possible

 

[Frank Kabel]

Hi
only with VBA (using an event procedure). Not with data validation
listboxes and functions alone

 

[Stephen Bye]

Not really, but you can have the dropdown list in C3 show different choices
depending on the contents of C2.
When you define the data validation for cell C3, for the source use a
formula like:
=IF(C2="HF",list1,list2)