I'm looking to make a reference to another sheet where if an
employee/date combination is found, the supervisor is pulled from the
other sheet.

Emp Day Super.
Bob Monday ????
Sam Tuesday ????
Mary Wednesday ????

the supervisor column is what i want to fill out, there is another
sheet in the workbook that would have this same information along with
other stuff that I don't need. I was thinking it would be something
along the lines of

{=(If((A2:A5="Bob") And (B2:B5="Monday")), C2:C5)}

but i can't seem to get it working