Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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?
ARRAY_LITERAL ERROR:until both queries/filters/formulas output something then all is good:
however if one of those queries/filters/formulas doesn't have anything to output it outputs #N/A - No matches are found in QUERY/FILTER evaluation. - the issue is that #N/A is only in the 1st cell:
but array expects that matrix on both sides to be same (4 columns from both queries/filters/formulas):
so we wrap each query into IFERROR and in case of error we output fake row with 4 fake columns - {"","","",""} - which will trick the array to output it like:
therefore try like this:
={{"","","","",""};
ARRAYFORMULA(IFERROR(VLOOKUP(AA4:AA, CUSTOMER_DATA, {2,3,4,5,6}, 0)))}
={"header";TRANSPOSE(FILTER(Sheet1!A2:A,Sheet1!H2:H=A2))}