Forum Discussion
Sorting Counties into Districts
Hi
I attach an example which I hope is what you want!
The formula is more complicate county list on the second sheet all have the word COUNTY after them. So I have had to remove it in order for the VLOOKUP to work. If you remove the COUNTY word yourself then you can remove the MID(FIND( formulas from the lookup.
If this is what you want I would be grateful if you could mark this as a completed solution.
thanks!
Peter
Hi
Sounds like VLOOKUP would do it.
Attach a sample of your data and I can take a look.
Peter
peteryac60 Here is the sample data! The main issue I encounter is getting it to transfer from the sheet where I have the districts listed out to the next sheet over. If I do it on the same sheet as where the districts are it works fine but I don't know what syntax to use to get it to transfer across all the sheets in my file. Thanks for the response!
Hi
I attach an example which I hope is what you want!
The formula is more complicate county list on the second sheet all have the word COUNTY after them. So I have had to remove it in order for the VLOOKUP to work. If you remove the COUNTY word yourself then you can remove the MID(FIND( formulas from the lookup.
If this is what you want I would be grateful if you could mark this as a completed solution.
thanks!
Peter