Using INDEX MATCH in place of OFFSET Functions

[ibrahimdaas]

Hi all,

I have the following attached file for Budget, where I use OFFSET to get the numbers to the main sheet.
Due to the very huge size of the budget workbook, it will take hours for me to open it and I think that is because of the OFFSET function.
My question is how can I use INDEX MATCH in the red tab in place of OFFSET and get the same exact results?

Thank you all
Budget.xlsx

[AliGW]

Before we start, have you asked this question on any other forum? I ask because you ignored my moderation post in your last thread.

If you have asked elsewhere, then the forum rules require you to declare this with link(s) as appropriate.

No help to be offered until this is resolved, please.

I have a suggestion for you as soon as you have responded to this moderation post.

[ibrahimdaas]

Hi

No , I have not asked elsewhere...only here

Thank you

[AliGW]

OK - thank you.

You could try INDEX MATCH:

=INDEX('Hotel PY'!$D$47:$Z$47,,MATCH("MTD",'Hotel PY'!$D$3:$W$3,0))

[AliGW]

You could also look up on the row like this:

=INDEX('Hotel PY'!$D$44:$Z$48,MATCH($B6,'Hotel PY'!$B$44:$B$48,0),MATCH("MTD",'Hotel PY'!$D$3:$W$3,0))

OFFSET is best avoided because of its volatility.