| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup in named range
Afternoon
Im currently creating a lookup formula between two worksheets, and would find it easier to make my formula search within name ranges rather than cell references. Im having problems making this work though. My current formula reads. =INDEX('Communal Areas'!A2:H804,MATCH(E2,'Communal Areas'!D2:D804,0),7) The name range for A2:H804 is Communal, and the name range for D2:D804 is Street. When I enter these though my formula comes back in error. I assume then that I am entering them into the formula incorrectly. Does anyone know how this should be done? Thanks in advance. J. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
| Address of named range | Excel Worksheet Functions | |||
Threaded Mode
