I have a list of zip codes we mailed to and a list of zip codes that people
responded from. Now some of list A is not in list B and vice-versa. I want
Excel to sort list A (easy of course) then line up list B next to the
corresponding zip code in list A. (I can create a List C of all zip codes in
the area since we have some responders that were not in the mailed zip codes)

Does anyone know a way for Excel to do this??

I fyou make a new table containing all zip codes in column A, Column B can be
a lookup of list A,and Column C can be a lookup of List B. Then columns B
and C will have List A and List B next to each other

Col A Col B Col C
11100 11100
11101 11101
11102 11102 11102
11103
11104 11104

Put equation in Column B
=if(Countif($F$1:$F$100,A1) 0,A1,"") <=F1:F100 is list A

Put equation in Column c
=if(Countif($J$1:$J$100,A1) 0,A1,"") <=J1:J100 is list B

"JSpence2003" wrote:

I have a list of zip codes we mailed to and a list of zip codes that people
responded from. Now some of list A is not in list B and vice-versa. I want
Excel to sort list A (easy of course) then line up list B next to the
corresponding zip code in list A. (I can create a List C of all zip codes in
the area since we have some responders that were not in the mailed zip codes)

Does anyone know a way for Excel to do this??