Can a workflow be designed to reference a data field in another sheet?

I am playing with the idea of creating a master reference sheet and using that as a cross reference for another. For example, I would have a master list of all leaders by geography. I am curious if I can devise a workflow based on selection of a geography (ie: USA) in another sheet, to send a message to the corresponding leader noted as a Contact in the master reference sheet.

Thoughts?

Thanks.

Bill

Comments