Hi,
I need some help finding a way to map a zipcode to a sales rep, based on a
match within a zipcode range assignment.

My lookup table has a ZipLow and ZipHigh value, with a Rep Id assigned to
the zipcode range. The zips are both US and Canadian Zip ranges

I have a 2nd worksheet that lists a specific address, and I want to compare
the zip of the address listed on this worksheet to see which rep would be
assigned based on the lookup table below.

Sample lookup table:

RepID ZipLow ZipHigh Country
Mark 33301 33999 US
Jim 34401 34999 US
Sam 35501 35999 US
Jill 47701 47999 US
Sue 48222 48999 US
Amy 60001 60999 US
John K0A 0A0 K9Z 9Z9 Canada
Jay L0A 0A0 P9Z 9Z9 Canada

Sample Worksheet that I need to populate with appropriate RepID:

Address/Zip Rep Assignment
60101 Amy
47801 Jill
P9Z 9Z6 Jay

I tried using Vlookup function with approximate match set with TRUE. It did
not work correctly in all cases.

Any suggestions????

Thanks so much,
Luce