| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range matching multiple named Ranges
I'm looking for a way to check ten different Named ranges to look for a match
within a another range. If there is a match, print a message as to which range matched (a possible 4 matches could exist at one time). =IF(named range 1=A1:A10,"yadda yadda yadda",IF(named range 2=A1:A10,"something something",IF.......to 10.) Also, when it prints the messages out, how would it place the results? Would it follow the order in which they are checked? I'm not sure that I'm going in the right direction here. Any help is appreciated.....Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| same named range on multiple worksheets? | Excel Discussion (Misc queries) | |||
| PivotTable - Multiple Consolidation Ranges | Excel Worksheet Functions | |||
| Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Threaded Mode
