Find the closest zip code from a list of office zip codes, to employee's home zip code

[mhabert53]

I have a list of employees, and a list of offices. I want to find which office location an employee is closest to, based on the employee's home zip code - so, find the closest zip code in the office list, to each employee's home zip code:

Employee Name	Home Zip Code			Office	Office Zip Code
Employee1	70713			Office1	60616
Employee2	70714			Office2	60618
Employee3	70715			Office3	60619
Employee4	70716			Office4	60620
Employee5	70717			Office5	60621
Employee6	70718			Office6	60622
Employee7	70719
Employee8	70720
Employee9	70721
Employee10	70722

<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>

Obviously all data is above is fake, just wanted to visually represent what I'm getting at. Is there an Excel formula or function that can help me do that, so that in the end I have a list of employees in one column, their home zips in another, and the closest office zip (and rest of office address I have), etc.?

Thanks in advance.

 

[mart37]

Maybe with MATCH()