#index

#REF! Error in Excel and Google Sheets: Causes and Fixes

#REF! means a reference is invalid. Tested: a VLOOKUP column too far right, INDEX off an array, INDIRECT, OFFSET off the grid, and a blocked SPLIT.