# Normal Formula and Array Formula

#### Irfanilham

##### New Member
I have question is it possible to combine a normal formula and array formula because as of my knowledge one only requires enter and another ctrl shift and enter. How do I combine them both if it is possible?

=IF(IFNA(VLOOKUP(M2,CHOOSE({1,2},IF('[Tier Price List.xlsx (Active)]Sheet4'!\$A\$2:\$A\$5=AX2,'[Tier Price List.xlsx (Active)]Sheet4'!\$E\$2:\$E\$5,""),IF('[Tier Price List.xlsx (Active)]Sheet4'!\$A\$2:\$A\$5=AX2,'[Tier Price List.xlsx (Active)]Sheet4'!\$F\$2:\$F\$5,"")),2,TRUE),"")<>"",
IFNA(VLOOKUP(M2,CHOOSE({1,2},IF('[Tier Price List.xlsx (Active)]Sheet4'!\$A\$2:\$A\$5=AX2,'[Tier Price List.xlsx (Active)]Sheet4'!\$E\$2:\$E\$5,""),IF('[Tier Price List.xlsx (Active)]Sheet4'!\$A\$2:\$A\$5=AX2,'[Tier Price List.xlsx (Active)]Sheet4'!\$F\$2:\$F\$5,"")),2,TRUE),""),

IF(IFNA(VLOOKUP(K:K,'[Price List 2020.xlsx (Active)]baseline format'!\$D:\$K,6,FALSE),"")<>"",IFNA(VLOOKUP(K:K,'[Price List 2020.xlsx (Active)]baseline format'!\$D:\$K,6,FALSE),""),IFNA(VLOOKUP(I2&K2,'[Price List 2020.xlsx (Active)]baseline format'!\$A:\$J,9,FALSE),"")))
p.s. (The formula in bold are the array formula)

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### AhoyNC

##### Well-known Member
You can enter a normal formula function with CTRL-SHIFT-ENTER and it should work just fine. So, just enter your combined formula with CTRL-SHIFT-ENTER.

ok

Replies
2
Views
58
Replies
1
Views
121
Replies
3
Views
130
Replies
1
Views
73
Replies
2
Views
170