Making a value range of zip codes convert to the corresponding county

[ssieber]

Ok so I have a pivot table with hundreds of thousands of orders. We have the zip codes in the last column. Now we have 10-15 worksheets with all of our monthly numbers corresponding to counties. We fired the broward county representitive and now one of our existing reps is going to take the county. However the accounting department refuses to make this easier by creating a Sales Rep 2 for him. So I am trying to add a column that has the county next to the zip code for all of the orders. It would take me years to type this out in each row. How can I create some sort of vlookup so that the county is automatically entered into a new column next to the zip code for that specific zip code value??

[NBVC]

If you have a table of all zipcodes and respective counties, then you simply use VLOOKUP

=VLOOKUP(X2,myCountyTable,2,FALSE)

where myCountyTable is your 2-column table....

Is that what you mean?

If not, can you post a small sample of what you have/need (remove confidential info)

[ssieber]

okk so i have a pivot table in rows for each order. I have the zip code at the end of each order. Now i have 2 territories, Palm Beach County and Broward County that one sales rep will be taking over. I need to be able to filter the info by county so that the numbers will be correct in our books just incase we hire someone new to take over one of those counties.So what I need is for a new coloumn to populate with the county name that corresponds to a zip code.
33418
33418
34997
34997
34997
33418
33418
33418
33418
33418
33418
33455
33455
33455
33455
34997
34997
34997
34957
34957
34957
34957
34994
34994
33065
33328
33305
33305
33441
33441
33308
33308
33431
34997
34997
34997
34957
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
34994
33458
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33178
33417
33417
33446
33445
33445
33409
33409
33414
33414
33446
33446
33446
33446
33446
33446
33446
33411
33436
33436
33434
33411
33478
33076
33413
33470
33470
33445
33445
33445
33411
33411
33496
33411
33067
33067
33428
33433
33445
So here is a small example of the zip codes for 2 counties. I would like to have a range of zip code values that = either palm beach or broward lets say column B will populate automatically next to column A (zip codes) for zipcode range 33300-33400 = broward, 33401-33499 = palm beach/ does this make more sence?

[NBVC]

So perhaps..

=IF(AND(A2>=33300,A2<=33400),"Broward",IF(AND(A2>=33401,A2<=33499),"Palm Beach",B2))

where A2 contains zipcode, and if none of the 2 match, then the value in B2 is returned (assuming B2 has another County name in it). You can replace B2 with "" if you want a null returned instead...