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.

--
HTH

Bob Phillips

"Micro" <tremendo1977@virgilio.it> wrote in message
news:%235Vj4nUgFHA.3868@TK2MSFTNGP14.phx.gbl...
> 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?
>
>
>