include in new column only if present in both columns

J

jb

i have two list of names of 500 to 1000 in size that are in two different
columns. I would like to generate a new column with names that are only
present in both list of names. help. thanks
 
R

roadkill

This probably isn't exactly what you want but your certainly welcome to try it.

If your first list is in column A and your second is in B1:B1000, in C1 you
could put:

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"",A1)

Then copy the formula down thru the last row of A column data.

You will end up with blanks in column C where a value from column A is not
in column B. Also if a given value can exist more than once in column A you
could have duplicates in column C. If there are no duplicates, at worst
you'd just need to copy column C over to a blank sheet and sort it to get rid
of the blanks

Will
 
Top