Match zones based on certain conditions VBA

Hello to all,

I have the following table.

In column A I have the Country Codes values and in column B corresponding description for each value (ZONE).

In Column D I have a list of numbers for which I want to look for the closest value in column A and if found put in column E the corresponding description (ZONE). The values in column E (ZONE) are the output desired for the input NUMBERS in D.

The basic condition is look the prefix, if a number in A is the prefix of a number in D (or vice versa), so the ZONE for the number in D should be the corresponding to that number in A.

Is there are more than one similar or exact matches, then the zone to select would be the first sorted ascending and if there is an exact match then zone would be that match exactly.

I hope make sense

COUNTRY CODE	ZONE		NUMBERS	ZONE
599	ANT		124	BRB45
61	AUS		12462	BRB5
124	BRB45		1246	BRB7
124622	BRB5		33	FRA1
1246	BRB7		3375012	FRA1
124623	BRB8		187635	JAM
124624	BRB92		18763044	JAM
237	CMR		23092	MUS
358	FIN		3162	NLD
33750	FRA1		49185	NOT FOUND
33751	FRA2		51078	NOT FOUND
334	FRA3		1721	SXM2
1876	JAM
230	MUS
31	NLD
65	SGP
1721	SXM2
1721	SXM4
1	USA

Thanks for any help.