| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Expanding Range for array-entered IF
I have an array-entered IF formula in Sheet 1 that looks up data in a range
of rows in sheet2 column a, and returns matching data from Sheet 2 column b to Sheet 1. I'd like to be able to insert rows in the middle of my range in Sheet 2 and have the array-entered IF formula in sheet 1 somehow adjust accrodingly. Does anyone know if this is possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto-expanding chart- dynamic ranges | Excel Worksheet Functions | |||
| How do I enable auto-expanding lists in a protected worksheet? | Excel Discussion (Misc queries) | |||
| expanding a range of numbers | Excel Discussion (Misc queries) | |||
| Need an Expanding array formula | Excel Worksheet Functions | |||
| Auto Expanding Pie Chart | Charts and Charting in Excel | |||
Threaded Mode
