Excel will automatically update any cell references that are expanded by the
insertion of a row(s), column(s), or cell(s), as long as the insertion is
done "within" the range. This includes references in array-entered
formulas.

HTH,
Bernie
MS Excel MVP


"veggies27" wrote in message
...
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?