Normal Formula and Array Formula

Irfanilham

New Member
Joined
Oct 2, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
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)
 

Some videos you may like

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
Joined
Oct 10, 2011
Messages
4,685
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,788
Messages
5,574,291
Members
412,584
Latest member
Leow
Top