Hi I have an excel workbook with 2 sheets, the first sheet has all the
information in it and the second is where I want the results displayed.
In sheet 1 have a row of dates (52 weeks of the year) in cells B1:BA1,
In column A starting at A2:A173 I have a list of names and in cells
B2:BA173 I have a list of duty numbers. In sheet 2 I have a formatted
form and on that form I want to create a formula that let's me enter a
date and a duty and return the name of the person doing that duty.

EG A B C D
1 2/1/06 9/1/06 16/1/06
2 JOHN 1 2 3
3 BILLY 2 3 1
4 TOM 3 1 2


If in sheet 2 I ENTERED 2/1/06 and duty 2, the result should be
BILLY

I have been wrecking my brains for weeks trying to solve this but
Can't, it would be much appreciated if someone could help me THANK YOU.