IF formula?

This is my quick and dirty solution.. I am sure some of the experts on here can put together something much more elegant. I inserted another worksheet and basically created a list of your zip codes from the top section and the tech name next to each one. Then I named the entire range "techzip". This formula is in cell I17 and can be copied down the column.

=IF(ISNA(VLOOKUP(F17,techzip,2,FALSE)),"",(VLOOKUP(F17,techzip,2,FALSE)))

However, your zip codes in your customer lists and the zip codes in the tech zone tables do not match which confused me at first.


Hope this help!

Clayton Grove

Originally Posted by dcgrove

However, your zip codes in your customer lists and the zip codes in the tech zone tables do not match which confused me at first.

Clayton Grove

my apologies. The actual sheet has 10 tabs for our different locations and about 300 records each and in trying to thin down I used disparate data.






I'll give this a whirl and see what happens.