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

Sounds like AutoFilter is your best bet. If not then please try to explain
the problem clearly.
HTH