I'm working on creating a duty schedule that will auto populate from a master sheet. The information will be from a range of cells that will change on a daily basis which is making this difficult to figure out. So for example:

A1 through A10 will be duty assignments
B1 through B10 will contain names

C7 is the cell I would like to contain the name of the person listed as N-1. So cell A5 will and N-1 and B-5 would be Phillips. How do I make cell C7 populate with Phillips?

Any help or input is appreciated.