Search for value on another sheet, return Y/N
 

I'm trying to have Excel consider EACH unique value in Column A (e.g. A2=1,
A3=2, A4=3...A6958=6957) on Sheet 1, compare each of these unique values with
an entire range of values in Column A (A2:A4352) on Sheet 2 (the Sheet 2
values in Column A are a subset of those on Sheet 1), and if a match found in
that range to return a value of Yes (or True)...if not, return a value of No
(or False)...to Column C in Sheet 1. Clear as mud???

Help! Thanks in advance!

Search for value on another sheet, return Y/N
 

=isnumber(match(a2,sheet2!$a$2:$a$4352,0))

Will return true if there's a match or false if there isn't a match.



Not Excelerated wrote:

I'm trying to have Excel consider EACH unique value in Column A (e.g. A2=1,
A3=2, A4=3...A6958=6957) on Sheet 1, compare each of these unique values with
an entire range of values in Column A (A2:A4352) on Sheet 2 (the Sheet 2
values in Column A are a subset of those on Sheet 1), and if a match found in
that range to return a value of Yes (or True)...if not, return a value of No
(or False)...to Column C in Sheet 1. Clear as mud???

Help! Thanks in advance!

--

Dave Peterson

Search for value on another sheet, return Y/N
 

You the man Dave! Thanks for your quick response, it works perfectly!
Incidentally, found a similar solution using COUNTIF:
=IF(COUNTIF('Sheet2'!$A$2:$A$4352,A2),"Y","N")

More than one way to skin a squirrel...sorry PETA people...just a saying.

Chris

"Dave Peterson" wrote:

=isnumber(match(a2,sheet2!$a$2:$a$4352,0))

Will return true if there's a match or false if there isn't a match.



Not Excelerated wrote:

I'm trying to have Excel consider EACH unique value in Column A (e.g. A2=1,
A3=2, A4=3...A6958=6957) on Sheet 1, compare each of these unique values with
an entire range of values in Column A (A2:A4352) on Sheet 2 (the Sheet 2
values in Column A are a subset of those on Sheet 1), and if a match found in
that range to return a value of Yes (or True)...if not, return a value of No
(or False)...to Column C in Sheet 1. Clear as mud???

Help! Thanks in advance!

--

Dave Peterson

Search for value on another sheet, return Y/N
 

or to just see true/false:
=(COUNTIF('Sheet2'!$A$2:$A$4352,A2)0)

You may find =match() a little quicker with lots of data--but =countif() is nice
when you have more than one column or row.

Not Excelerated wrote:

You the man Dave! Thanks for your quick response, it works perfectly!
Incidentally, found a similar solution using COUNTIF:
=IF(COUNTIF('Sheet2'!$A$2:$A$4352,A2),"Y","N")

More than one way to skin a squirrel...sorry PETA people...just a saying.

Chris

"Dave Peterson" wrote:

=isnumber(match(a2,sheet2!$a$2:$a$4352,0))

Will return true if there's a match or false if there isn't a match.



Not Excelerated wrote:

I'm trying to have Excel consider EACH unique value in Column A (e.g. A2=1,
A3=2, A4=3...A6958=6957) on Sheet 1, compare each of these unique values with
an entire range of values in Column A (A2:A4352) on Sheet 2 (the Sheet 2
values in Column A are a subset of those on Sheet 1), and if a match found in
that range to return a value of Yes (or True)...if not, return a value of No
(or False)...to Column C in Sheet 1. Clear as mud???

Help! Thanks in advance!

--

Dave Peterson


--

Dave Peterson