Matching a source list to a bigger list

[agentnj]

Apologies for the poor articulation.

I have a master list of clients and the specialists assigned to them on one worksheet (Client Assignment) that changes daily. I also have a list of deadlines for each client, where each client has a number of deadlines.

I'd like to write a formula that automatically searches the Client Assignment page and applies the specialist name in the Deadlines tab, so that I do not have to manually change the Deadlines sheet every time the Client Assignment worksheet changes.

Example attached.

[Paul]

Hi Agentnj, and welcome to the forum. Perhaps try the following VLOOKUP formula in cell B2 of the sheet 'Deadlines':

=VLOOKUP(A2,'Client Assignment'!A:B,2,0)