Arrayformula inside an array in google sheets

Question

I have the following formula in google sheets which works perfectly in the row 3.

=ArrayFormula(if(len($A$3:$A),vlookup($A$3:$A,'All records in progress'!A2:BE,{57,6,7,8,9,10,11,13,14,31,32,33},FALSE),""))

However, I would like to have the formula in the row 2 with the header so I was trying to create something like this:

={"Header"; ArrayFormula(if(len($A$3:$A),vlookup($A$3:$A,'All records in progress'!A2:BE,{57,6,7,8,9,10,11,13,14,31,32,33},FALSE),""))}

So I could have the word Header in the first row and the formula from the next row onwards. However, my formula is not working. Do you know if how I could achieve this?

Looking forward to your reply.

Cheers,

player0 · Accepted Answer · 2021-01-14 22:33:08Z

1

your vlookup returns 12 columns so you need:

={{"Header","","","","","","","","","","",""}; 
 ARRAYFORMULA(IF(LEN(A3:A),
 IFNA(VLOOKUP(A3:A, 'All records in progress'!A2:BE, 
 {57,6,7,8,9,10,11,13,14,31,32,33}, 0)), ))}

answered Jan 14, 2021 at 22:33

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Arrayformula inside an array in google sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related