I am using a Mac.
I have 3 categories of ZIP Codes, Zone 1, Zone 2 and Zone 3. I have a list of ZIP Codes and I need to see easily if a zip code is zone 1, 2 or 3.
Column E holds my ZIP Code. Column F has my zone listing, with value 1, 2 or 3.
Sheet 2 holds my ZIP Code list, but it is massive. One is 514 rows. I am currently doing this manually and it's taking forever.
My Vlookup formula is shown in the image, and gives me an error.
Realistically, it would be great if it returned a value of 1, 2 or 3. However if it just returned anything and I had to go through each column of ZIP Codes, even that would be great.