Auto Expanding Ranges?

V

veggies27

Joined
Mar 5, 2008
Messages
4
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Expanding Range for array-entered IF 3
Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
delete row formula changes array range on related sheet 8
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Need VLOOKUP to Work Two Ways 0
VBA Autohide Help 6
Replacing a data range in a nested array function 1

Top