I have a worksheet full of addresses, including postal codes from many towns (approx 40) in two Counties.
I have a worksheet with all postal codes from County A, and one with all postal codes from County B
I need to:
a) match the addresses to which ever County they belong.
b) I then need to know how many people are from each postal code from both County A and County B
Can I get any help with this please. I think its Vlookup but really not sure on these complicated formulas. I am using excel 2003
Thank you in advance
Bookmarks