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

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","Opera tor")



Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558017

Thanks Dav, that worked perfectly.

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

Appreciated your help...

"Dav" wrote:


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","Opera tor")



Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558017

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

=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)

"Shavey" wrote in message
...
How do I clear the cell if the reference cell is empty?