=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