match data in 2 columns and return value in relative adjacent cell

[bjbeamish]

Hello experts!

I need some of your kind help -= I have 3 columns of data: Column C has a list of employee IDs, column D has a range of dates and column E has a time.

I need to return the time that is in the same row as the employee ID and the date.

I know it has something to do with match/index/vlookup but not sure how to begin!

I need the 2 conditions to be satisfied before the data is returned i.e. I need the employee id AND the date to be in the same row before the time (in the same row) is returned.

I hope that makes sense - please ask for clarification if it doesn't. I want to add an example table for you but not sure how - sorry!

Many thanks
Brian

 

[bjbeamish]

Thank you Danny! I'm out of time at the moment so will have to test tomorrow but thank you so so much so far! I'll let you kow whether it works tomorrow - many many thanks!

Brian

 

[bjbeamish]

Many thanks Danny - that works a treat - I now have a new question to ask so will post a new thread - thank you SO much for your time on this one.

All the best
Brian