SOLVED

# Spill error

Copper Contributor

# 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

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

# Re: Spill error

@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.

# Re: Spill error

Thank you so much, appreciate you
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

# Re: Spill error

@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.