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...
Very late comment, but I was just encountering this problem and solved it. Go to the backstage (File tab)-->Options-->Formulas, and under "Calculation options," make sure "Workbook Calculation" is set to "Automatic."