If you want to sum something, you can use
=SUMPRODUCT(--(staff_id=123),--(date_range=--"2005-03-01"), amount_range)
If you just want to get a value use
=INDEX(amount_range,MATCH("123"&=--"2005-03-01",TEXT(staff_id,0)&date_range,
0))
as an array formula
--
HTH
Bob Phillips
"WendyL" wrote in message
...
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?
|