| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
named ranges in multiple criteria formula
I'm not sure what formula to use . I have 10 columns of numbers each with
their own name as a heading. SICU is a named range for room numbers 300-350 .....c2:c51 MICU is a named range for room numbers 400-476......d2:d77 ORTHO is a named range for room numbers 500-583......e2:e84 I want to enter a room number in B2 and have the name of the floor populate A2 So if I enter room number 410 in B2 the answer MICU would fill in A2. Is this possible? Thank you in advance for any help you can provide Ferde |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use named ranges in array formula | Excel Worksheet Functions | |||
| using named ranges for formula abbreviations | Excel Worksheet Functions | |||
| Sumproduct using named ranges and multiple criteria | Excel Discussion (Misc queries) | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Threaded Mode
