Forum Discussion
Array Vlookup Will Not Autofill
In previous versions of Excel I have been able to use the auto-fill feature when using an array vlookup. The formula is straight forward, I have data in column A, E, F, and G with column Headers i...
VLOOKUP returns spill into B2:C2 (you don't need CSE), with it double click doesn't work, with it autofill doesn't work. You may select the range and Ctrl+D.
Formulae such as =left(A2,2) or =SUM(K2:O2) return single values, not spilled array.