Using IF function and validation list

[Guest]

I want to return a result, "Operator" or "Hotel" using a drop-down list. The
data for the drop-down is listed on another worksheet.

D4 =IF(C4="Summary!A5:A40","Operator","Hotel")

C4 is the dropdown list and the cell in question D4, would return the result

"Summary!A5:A40" is the range of the validation on that I want assigned to
"Operator" with the remainder Summary!A41:A60" to be assigned "Hotel"

Thanks

 

[Dav]

Im not sure why you need a dropdown list for d4, if the value to be
returned is the result of matching it from another list.
IF(isna(match(c4,summary!a5:a40,0)),"Hotel","Operator")



Regards

Dav

 

[Guest]

Thanks Dav, that worked perfectly.

D4 is not a dropdown but rather the outcome of the IF formula.

Appreciated your help...

 

[Guest]

How do I clear the cell if the reference cell is empty?

 

[Bob Phillips]

=IF(c4="","",IF(isna(match(c4,summary!a5:a40,0)),"Hotel","Operator"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)