| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search and return | Excel Worksheet Functions | |||
| Search for first instance of text & return the value | Excel Worksheet Functions | |||
| search for and return more than one row in a sheet | Excel Worksheet Functions | |||
| Search array and return element No | Excel Worksheet Functions | |||
| Search and replace with Carriage return | Excel Discussion (Misc queries) | |||
Threaded Mode
