Dear All,

I have a list of 100 names , and i want to make sure that those names are in
another list of 1500 name ..
how can I do this ?

Thanks in advance

Assuming the list of 1,500 names are all within the same column...you can use
the vlookup function within an If statement. I use it all the time.

If a name in the list of 100 is in the list of 1,500 it will return a "YES",
otherwise a "NO".

=IF(ISERROR(VLOOKUP(A4,B$4:B$1504,1,0)),"NO","YES" )

The cell A4 is the first cell in your list of 100.
B4 to B1504 is your list of 1,500 names.

If a name in column A is not in column B, it will generate an error, which
triggers a result if TRUE in the ISERROR() funtion, in turn triggering a TRUE
for the IF() statement.

Copy the equasion to each cell in your list of 100.


"Tahani" wrote:

Dear All,

I have a list of 100 names , and i want to make sure that those names are in
another list of 1500 name ..
how can I do this ?

Thanks in advance