| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search cells in a column and return yes/no if they are present in named range
Hi,
Please help, I'm trying to select a particular column and then search each cell in that column to see if any of the values exist in a named range, i want to do this for each sheet in the workbook. For example: I have 4 worksheets in by workbook, 3 of which all contain Site field (column B). The 4th sheet contains a named range ("SITE") I want to check that each site in column B (all sheets)exists in the named range on the 4th sheet. Is this possible, thank you in advance Felicity |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a named range | Excel Worksheet Functions | |||
| Search range of cells for word & return value for use in formula? | Excel Worksheet Functions | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Query Named Range Return Single Column Value | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Threaded Mode
