I have a list of zip codes in one worksheet that i want to populate with county names based on another worksheet .
file attached
Zip code and county fill based on zip code data
-
-
Re: Zip code and county fill based on zip code data
Welcome to the forum.
Without a spreadsheet which is a good idea when posting it is hard to see what your output is. By the sound of it you need something called a VLookup. But post that file or a smaller version of the file so it fits on the site.
Take care
Smallman
-
Re: Zip code and county fill based on zip code data
hi i tried to upload this file a few times , i get errors , here is the link to google drive ,
https://drive.google.com/file/…QZnI4bzg/view?usp=sharing
Quote from Smallman;764141Display MoreWelcome to the forum.
Without a spreadsheet which is a good idea when posting it is hard to see what your output is. By the sound of it you need something called a VLookup. But post that file or a smaller version of the file so it fits on the site.
Take care
Smallman
-
Re: Zip code and county fill based on zip code data
use the below formula in cell d2:
=IFERROR(VLOOKUP(B2*1,'NY ZIP MAP'!A:C,3,FALSE),"")
-
Re: Zip code and county fill based on zip code data
Thank you very much !!! Works like a charm
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!