hard match!!

[Micro]

I have an xls with 2 sheets.
In the first sheet I have 4 columns containing names.
In the second sheet I have 2 columns, the first (column A) containing all
the names used in the 4 columns of the first sheet previously described; the
second one (column B)
contains the results of the following function:

=isnumber(match(a2,sheet1!a:a,0)) & "." &
isnumber(match(a2,sheet1!b:b,0)) & "." &
isnumber(match(a2,sheet1!c:c,0)) & "." &
isnumber(match(a2,sheet1!d:d,0))

This function takes in input the name in a2 and tries to find it in the four
column of the sheet 1, and outputs me in the column B of the sheet 2
something like "true, true, true, true" or "false, true, false, true" in the
case it finds or not the name in the column.

OK

The problem is that I have to use this function for all the names in the
column A of the seet 2 and it is difficult form me as in the column A I have
something like 24000 names.
Is it possible to parametrize the function described in an automatic way
that fills the column B showing the results of the matching?

 

[Bob Phillips]

What exactly is the problem?

If you put that formula in B1 and just copy down, it automatically updates.