| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding info within a data set
This is probably easy, but I'm having a heck of a time figuring out the
formula. I have two spreadsheets with similar data. I am trying to figure out if the data in a cell (B2) on spreadsheet A (a value like "A452") exists at all anywhere within a column (M) on spreadsheet B (where the cells read like "A002, A452, A223"). Since the data can be anywhere in the cell, and anywhere in the column, I can't seem to find a formula to work. Help! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) | |||
| Finding Info from Column A and Removing it from Column B | Excel Discussion (Misc queries) | |||
| Finding info of one column and removing it from another | Excel Discussion (Misc queries) | |||
| Finding data | Excel Discussion (Misc queries) | |||
| finding data | Excel Worksheet Functions | |||
Threaded Mode
