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