Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/10/VLOOKUP-SPILL-ERROR.xlsx

In the video I show you how to fix the #SPILL! error when using VLOOKUP. The #SPILL! error indicates that there is not enough cells for the formula to display its results in. Excel 365 supports dynamic array formulas where a single formula is capable of displaying multiple results. The array of results are spilled into surrounding cells.

Excel 365 warns users that get this error that the formula they have entered may spill beyond the edges of the worksheet. This warning occurs when the user selects an entire column in the lookup_value argument and the VLOOKUP has been typed into a row other than row 1.

Excel offers to correct the formula with an '@' symbol in front of the lookup_value. The '@' symbol forces an implicit intersection where multiple results are collapsed down into one. The result that is displayed is the one that shares the same row as the formula.
------------------------