REFERENCE ... VLOOKUP ... OFFSET... MATCH?

  • Thread starter Michel Khennafi
  • Start date
M

Michel Khennafi

Good afternoon

I have a situation where I need to assign a zone number to a order number
based on where the order is originating. In my situation I am dealing with
Canadian Zip Codes and they have a pattern like ANANAN (where N=number and
A=character)

In spreadsheet 1, my supplier gave me a list of zips like "from zip codes
starting to B20 to zip codes B2Z = Zone 1"
which translates into a table with 3 columns Start Zip-3 from, Start Zip-3
to and zone number

In spreadsheet 2, I have a list of all the orders and the exact zip codes.

What would be the best way for me to lookup the zone number in my
spreadsheet 2 and to insert it into a cell on the same row as my order
number? Any idea of the formula i need to write to get the zone number based
on the first 3 digits of my zip codes, check it in the spreadsheet 1 and
import it in my spreadsheet 2?

Thanks so much


Mk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top