IF formula?

Folks – looking to automate a task.

We have geographic zones assigned to field personnel based on our customer’s zip codes.
Our customers change every day.
Our geographic zones do not change.
I want to have our employees’ tech number automatically placed in the cell (same row) as the customers’ zip code if it is in their area.


Is it possible to create a zip code list and have the cell automatically populated with the field employee’s number based on the zip code list? I have attached a small file that has our zip code list format as well as the customer base info.

I have some experience with IF formulas but this one seems tricky.