Hi,

Is there any way that VLOOKUP can lookup 2 cells to report data back,
example, I have a table of staff names that can work on certain days of the
week per dayshift and per nightshift, I am needing to input a date into a
cell and the N/S or D/S into another cell and I need the staff names to be
input into cells that can work on each of the dates either N/S or D/S, can
this be done or is there some other function that I can use?

Any help would be great.

Many thanks

Mark