Comparing data between sheets and adding cell data

Hi all,

I have two sheets. The first includes names of people and their normal work shift (AM or PM)
On a second sheet, I am regularly pasting a roster of all employees onto Column A. I would like that the text "AM or "PM" will be appropriately added to column B based on the info that is found within the first sheet.

Any thoughts?

Thanks,
Eitan

In B1 of sheet2, use the following formula:

=IFERROR(INDEX(Sheet1!$B$1:$B$20,MATCH(Sheet2!$A1,Sheet1!$A$1:$A$20,0)),"")

Make sure that the ranges (here rows 1-20) fit or exceed your list on sheet1 and fill the formula down through column B of sheet two as far as you think you'll need. It'll show a blank until a corresponding entry is made in column A, then it'll perform the lookup and populate the cell. See attached for more clarity:

You are a Star! Thanks so much

Eitan

Glad to help, good luck!