Yes. How are you settingup your rows and columns?
--
Gary's Student


"WendyL" wrote:

I am trying to set up a wages template for over 300 staffs, showing starting
and finishing times, hours worked, staff ID etc. I want to use 'Staff ID' and
'Date' as the search terms to help me calculate the hours work for staff. I
am unable to loacte any info online. I can only see 2-D vlookup and that
doesn't work because the date are in columns and not rows. Can anyone help
me?