Hi,
I havent been able to find an answer to my query, and I have tried so many variations to make OFFSET (left by one cell) work but I am not having any luck.
My original formula is:
=INDEX(General2!$D$4:$AAA$400,MATCH($I5,General2!$B$4:$B$400,0),MATCH($E$7,General2!$D$2:$AAA$2,0))
I have tried to apply the OFFSET part of the formula and the closest I am getting is:
=INDEX(OFFSET(General2!$D$4:$AAA$400,MATCH($I5,General2!$B$4:$B$400,0),MATCH($E$7,General2!$D$2:$AAA$2,0)),,1)
However, the issue with this is that it is offsetting both to the left and down by one cell each. I am trying to just OFFSET by one cell to the left, and not down.
Any help would be greatly appreciated!
I havent been able to find an answer to my query, and I have tried so many variations to make OFFSET (left by one cell) work but I am not having any luck.
My original formula is:
=INDEX(General2!$D$4:$AAA$400,MATCH($I5,General2!$B$4:$B$400,0),MATCH($E$7,General2!$D$2:$AAA$2,0))
I have tried to apply the OFFSET part of the formula and the closest I am getting is:
=INDEX(OFFSET(General2!$D$4:$AAA$400,MATCH($I5,General2!$B$4:$B$400,0),MATCH($E$7,General2!$D$2:$AAA$2,0)),,1)
However, the issue with this is that it is offsetting both to the left and down by one cell each. I am trying to just OFFSET by one cell to the left, and not down.
Any help would be greatly appreciated!