Thanks Harlan for your guidance, problem now is it returns a #N/A value.

In my test data I only have 4 rows, with each named range being the same
size, so not sure why. The value returned in B13 does appear in the range
"StaffNo_HoursWorked" as does the value in H9 in Date_HoursWorked


"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1145577651.580408.100790@g10g2000cwb.googlegroups.com...
> John wrote...
>>I have the following Index formula which is not producing the correct
>>result
>>and I am unsure of why
>>
>>{=INDEX(StartTime_HoursWorked,MATCH(1,
>>(Date_HoursWorked=H$9)*(StaffNo_HoursWorked=$B$13)))}
> ...
>
> The problem is that you're looking for the first exact match, so you
> need to include the 3rd argument to MATCH, and that argument needs to
> be zero or FALSE.
>
> =INDEX(StartTime_HoursWorked,MATCH(1,
> (Date_HoursWorked=H$9)*(StaffNo_HoursWorked=$B$13),0))
>