I have a spreadsheet that has typical address element City, State, Zipcode. I also have a column called District that I would like to put a number in based upon zipcode. .
I have been doing this manually and with 615 records it is time consuming. I have played with name ranges. I put the zipcodes in columns as they relate to a particular district.
I have tried Vlookup that didn't work, I tried Pivot table. I know there is someone smart out here in the cloud that give me better guidance than my mind is coming up with.
I would appreciate any assistance offered. I have limited experience. Many Thanks Rick
Populate a cell based upon Name Range
-
-
-
Re: Populate a cell based upon Name Range
If you define the zipcodes per district, you can use VLookup for that.
Probably you get better help with an excel file (without confidentional information).
-
Re: Populate a cell based upon Name Range
Thanks you for the tip. I have 9 columns of zipcodes each column is a district 1 - 9. Should the districts be in a separate column or used as column headers?
-
Re: Populate a cell based upon Name Range
I find it hard to tell, how you can solve it, without seeing your data.
-
Re: Populate a cell based upon Name Range
Below are the two sheets. I am trying to tell the main spreadsheet to put corresponding number District Number (e.g. 1) in the district column if the zipcode is one of the zipcodes for that district. If no match put a 2, or 3 whatever is applicable. Hope the picture helps.
[ATTACH=CONFIG]51984[/ATTACH][ATTACH=CONFIG]51985[/ATTACH]
-
Re: Populate a cell based upon Name Range
Put all zip code in one column (e.g. A)
Put the district in the adjusting column (e.g B)
Then you can use VLookup to find the district.
-
Re: Populate a cell based upon Name Range
Can I just put the name range for each zipcode group by district, that way it would not be as long.
Column A Column B
ZIPCODES Districts
ZIP1 1
ZIP2 2
ZIp3 3
ZIP4 4
ZIP5 5
ZIP6 6
ZIP7 7
ZIP8 8
ZIP9 9 -
Re: Populate a cell based upon Name Range
Post the excel file and i show it you.
-
Re: Populate a cell based upon Name Range
forum.ozgrid.com/index.php?attachment/51989/ Hope this works I've never upload/attached a file before.
-
Re: Populate a cell based upon Name Range
See the attached file.
Do you have questions or comments, just ask or comment.
-
Re: Populate a cell based upon Name Range
Thanks was beautiful, You are awesome, Thank you so very very much.
-
Re: Populate a cell based upon Name Range
Thanks for the reply.
Thanks for the compliment.
Glad I could help.:)
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!