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?