Need help with a Formula
 

Hi,
Does anyone know what formula to use, or how to make 2 columns match? For
instance Column A has 100 names and Column B has 65 names. So on Column C, I
need the Column B names to match up with the Column A names, so I can find
out the 35 missing names.

Anyone know how to do this?
R

Need help with a Formula
 

In C1, enter
=IF(ISERROR(VLOOKUP(A1,B:B,1,FALSE)),"",A1)
and copy down for as many rows as there is data in column A. The blank cells
in column C will be the missing names.

Hope this helps,

Hutch

"clueless" wrote:

Hi,
Does anyone know what formula to use, or how to make 2 columns match? For
instance Column A has 100 names and Column B has 65 names. So on Column C, I
need the Column B names to match up with the Column A names, so I can find
out the 35 missing names.

Anyone know how to do this?
R