jarvisjaska
New Member
- Joined
- Jan 13, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I'm having a problem trying to get offset value with index,match. The following formulas both work fine:
But when I use
Excel returns #VALUE! -error.
I think this is because offset doesn't work on array, but is there any other way to do this?
Excel Formula:
=OFFSET(INDEX('Sheet1'!H:H;(MATCH(A7;'Sheet1'!C:C;0)));1;0)
=INDEX('Sheet1'!H:H;FILTER(MATCH($A:$A;'Sheet1'!$C:$C;0);ISNUMBER($A:$A)))
Excel Formula:
=OFFSET(INDEX('Sheet1'!H:H;FILTER(MATCH($A:$A;'Sheet1'!$C:$C;0);ISNUMBER($A:$A)));1;0)
I think this is because offset doesn't work on array, but is there any other way to do this?