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.
Bookmarks