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!
|