Forum Discussion
Solved
Spill error
Hi
I have been using this formula for years and it worked perfectly since upgrading to 356 I am now getting a spill error -
=IFERROR(INDEX(Master!$B$2:$B$18623,MATCH('Inv-WH'!$A$2:$A$9346,Master!$A$2:$A$18623,0)),"")
This helps me to fetch info from a specific column and return the info correctly
Stephen_Marr Because of 'Inv-WH'!$A$2:$A$9346, as first argument in MATCH, the formula returns 9345 rows. Perhaps use
=IFERROR(INDEX(Master!$B$2:$B$18623,MATCH('Inv-WH'!$A2,Master!$A$2:$A$18623,0)),"")
and fill down.
2 Replies
Stephen_Marr Because of 'Inv-WH'!$A$2:$A$9346, as first argument in MATCH, the formula returns 9345 rows. Perhaps use
=IFERROR(INDEX(Master!$B$2:$B$18623,MATCH('Inv-WH'!$A2,Master!$A$2:$A$18623,0)),"")
and fill down.
- Thank you so much, appreciate you
