# 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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### 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
57
Replies
1
Views
119
Replies
3
Views
128
Replies
1
Views
73
Replies
2
Views
170