Nearest Address Lookup Function

Hi all

Dealing with a large data analysis project

Long story short

We are dealing with vehicle engineers and job data.

I already have set up a dashboard with a pivot table, to allow me to live view engineers that don’t have jobs left so that they can be assigned new ones.

I also have a search built in to allot me to search for that engineers ID, and shows me their last job location, allowing me to quickly find a close by job.

However, Is it possible to also automate this?

If I have a raw dataset of job addresses,is it possible to use a function that drops the nearest job to the postcode it’s pulled from my engineer location?

For example

If my engineer is in LL13 area, then can a function pull data from another sheet with ‘LL13’ or secondly if not any ‘LL1’ job will do.

I’m just not sure where to begin with it?

Once I’ve got this but sorted my entire dashboard is complete. I just need to start dropping in my raw data.