I am trying to make my workbook pick up the dates employees are taking
holidays. Then I need to book in relief for those shifts. I want to be able
to see if I have double booked a relief employee. So I need to use a formula
that looks up the date and employee name. I tried hlookup and vlookup but
that did not work. Is there anyone that can help me choose the right
formula???