I've been trying to get this array formula to work, but I get an error. It's just a vlookup
array to display multiple columns. It works fine without the {"";
bit, but I want it to drop down one row.
={"";ARRAYFORMULA(IFERROR(VLOOKUP($AA$4:$AA,CUSTOMER_DATA,{2,3,4,5,6},FALSE),""))}
Without
=ARRAYFORMULA(IFERROR(VLOOKUP($AA$4:$AA,CUSTOMER_DATA,{2,3,4,5,6},FALSE),""))
How do I get this to work?