excel help - array formula how to fill down

[Mallesh23]

Hi Team,

I have one question on Array formula, Below is array formula it works after hitting Control + Shift + Enter

What is the correct way to enter formula.

apply on single cell, and fill down or
Select Multiple cells and type formula and fill down... sometime I get same first cell value fill down.

=IF(D5>0,IFERROR(INDEX($C$2:$C$5,MATCH($F5&"|"&$E5,$A$2:$A$5&"|"&$B$2:$B$5,0)),"-"),"-")

Thanks for your help.


Thanks
mg

 

[Fluff]

It needs to be entered into one cell using FormulaArray & then fill down.

 

[Mallesh23]

Hi Fluff,

Thanks once again for your help, I was not sure, I will follow it. thanks


Thanks
mg

 

[Fluff]

You're welcome & thanks for the feedback.