Hi,

Could you show us a sample of your data layout.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TWP" wrote:

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???