1

I'm having trouble applying the following formulas to entire columns in Google Sheets. I think that an array is the best option because there are 5000+ rows, but any help is appreciated. I'm really stuck.

  1. =(IF (K2<>"", K2, IF(Q2<>"", Q2, IF(T2<>"", T2, IF (W2<>"", W2, W2)))))

    I tried: =ARRAYFORMULA(IF (K2<>"", K2, IF(Q2<>"", Q2, IF(T2<>"", T2, IF (W2<>"", W2, W2)))))

  2. =(IF(A2=A1,C1+1,1))

    I tried: =ArrayFormula(IF(A2=A1,C1+1,1))

  3. =if(C2="2019-January", "NEW")

  4. =VLOOKUP(E2, $AA$2:$AA$13,1, false)

  • trouble applying = ? What results if you drag one of those down and what is your desired outcome? In the example of =VLOOKUP(E2, $AA$2:$AA$13,1, false), E2 should change to E3, E4, E5, etc.. are you not experiencing that? – Eric F Apr 30 at 17:46
  • pls share a copy of your sheet – user0 Apr 30 at 19:48
  • @EricF thanks for replying! If I drag any of these formulas, they work, but it takes forever. I'll share a copy of the sheet with dummy data asap. – Christina May 1 at 17:11
  • @user0 thanks! i will! – Christina May 1 at 17:12
1

1:

=ARRAYFORMULA(IF(LEN(K2:K&Q2:Q&T2:T&W2:W),
 IF(K2:K<>"", K2:K, 
 IF(Q2:Q<>"", Q2:Q, 
 IF(T2:T<>"", T2:T, 
 IF(W2:W<>"", W2:W, W2:W)))), ))

2:

=ARRAYFORMULA(IF(A2:A=A1, C1+1, 1))
=ARRAYFORMULA(IF(A2:A=A1, C1:C+1, 1))

3:

=ARRAYFORMULA(IF(TO_TEXT(C2:C)="2019-January", "NEW", ))

4:

=ARRAYFORMULA(IFERROR(VLOOKUP(E2:E, AA2:AA13, 1, 0)))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.