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

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
Joined
Oct 10, 2011
Messages
4,687
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,961
Messages
5,575,252
Members
412,651
Latest member
caitlincole
Top