matching two cells and giving a value from a third if it is a match

[scottfshr]

I have a excel sheet with first and last name in separate cells and hours planed to work fr each day in separate cells. I am want be able to enter the first name and last name and have the hours planed for each day fill in.

 

[mrshl9898]

Say you have First name in Sheet1 column B, Last in C, and Time in D. In A have =B2&" "&C2.

Then on the sheet where you enter the full name in A1 have =VLOOKUP(A1,'Sheet1'!A:D,4,0)

 

[scottfshr]

OK got the first part to work thank you. the Vlookup is giving me a challenge. I have hours scheduled in other columns M,N, S, T, y, z cycle continues out, skipping 7 cells counting the next two, for 7 days