Spill error

Copper Contributor



I have been using this formula for years and it worked perfectly since upgrading to 356 I am now getting a spill error - 



This helps me to fetch info from a specific column and return the info correctly

2 Replies
best response confirmed by Grahmfs13 (Microsoft)

@Stephen_Marr Because of 'Inv-WH'!$A$2:$A$9346, as first argument in MATCH, the formula returns 9345 rows. Perhaps use




and fill down.

Thank you so much, appreciate you