identify missing data b/t columns and then paste in anthoer column
 

hi all,

I would like to compare two columns of data (alpha & numeric) - List A and
List B, against one another and identify those data that are missing from
List A and then paste this data into a new column with no blank cells between
them.

I am playing around with something like the following but not having much joy;


=IF(B2="","",IF(ISNUMBER(MATCH(B2,'Enter SURVEY DATA'!B:B,0)),"",ROW()))

and then

=IF(ISERROR(SMALL('Enter CORVU DATA'!E:E,ROW('Enter SURVEY
DATA'!B2))),"",INDEX('Enter SURVEY DATA'!B:B,MATCH(SMALL('Enter CORVU
DATA'!E:E,ROW('Enter SURVEY DATA'!B2)),'Enter CORVU DATA'!E:E,0)))


thanks very much
pete