View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Not Excelerated Not Excelerated is offline
external usenet poster
 
Posts: 1
Default 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!