C
colescand
I need help with a formula, I think I need to use VLOOKUP.
I have a group of zipcodes of specific locations in column A, and a blank column B for the congressional districts of those zip codes. In column C I have all possible zipcodes, and in column D I have the appropriate congressional district number matched up with each zip code in column C. (I.e., if Ihave zip code 11111 in column C, and that area code is in district 1, thanI have the number 1 in column D). I need excel to first match zipcodes from column A and C, and when they match, see which district number is attached to the column C zip code, and paste that into column B.
VLOOKUP formula? Or am I on the wrong track here?
I have a group of zipcodes of specific locations in column A, and a blank column B for the congressional districts of those zip codes. In column C I have all possible zipcodes, and in column D I have the appropriate congressional district number matched up with each zip code in column C. (I.e., if Ihave zip code 11111 in column C, and that area code is in district 1, thanI have the number 1 in column D). I need excel to first match zipcodes from column A and C, and when they match, see which district number is attached to the column C zip code, and paste that into column B.
VLOOKUP formula? Or am I on the wrong track here?