How can I prioritize which result is displayed?

[Clockpart]

In my company, we use a workbook to display our schedule, organized by unit. Data are input in 2 locations spreadsheets in the book, but often someone can have more than one action scheduled on a given day. Is it possible to tell Excel, based on which spreadsheet the result is pulled from, to display one instead of the other?

[dosydos]

Most likely Yes

[Clockpart]

Ok, any idea how to write the formula or which function to use?