Hi,

I have two vlookup functions on sheet 1

I would like it to search the date I have typed in A1 sheet 1 and the shift I have entered in sheet 1 B1 and return a result of data in C1

Sheet two is where the data is stored and has the below information

Date - Shift - Workers On
11/1/14 - DAY - 5

Therefore if in sheet 1 in A1 I enter the date and in sheet1 B1 I enter D, C1 will return 5

Please help