Match Zipcode to correct range and extract description

[VacoBeginner]

Hi all

I think this is could be a challenge, at least it is for me and would appreciate all the help I can get.
I need to extract name in field Zone Description from the actual postal code and country code.
I need to match Country Code and if postal code is higher than or equal to Postalcode range start and lower than or equal to postal code end.
The ranges are in this file:
https://www.dropbox.com/s/d2cjbplwycapgwj/PostalCodeRanges.xlsx?dl=0

I´m interested in both in formulas solution and VBA script.

Thankful for help

Regards

Vacobeginner

 

[mole999]

Re: Match Zipcod to correct range and extract description

postcodes in the UK typically cover 50 properties, so getting names is a chore