CODEWITHSUNDEEP
excel
McBooley
McBooley

Reputation: 433

Excel formula returning a blank space

enter image description here

So I want to search for the values in column C, but when I press Enter after writting the formula it return a blank cell, if I format it with F9 though it returns the right value.

=IFERROR(INDEX($C$3:$C$994;SMALL(IF(ISNUMBER((SEARCH($F$3;$B$3:$B$994))*
(SEARCH($H$3;$D$3:$D$994)));ROW($D$3:$D$994)-MIN(ROW($D$3:$D$994))+1;"");ROW(A1)));"")

What could cause this problem?

Upvotes: 0

Views: 124

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34370

It's an array formula so needs to be entered with CtrlShiftEnter

F9 also forces the formula to be evaluated as an array formula so that's why you get the correct result: otherwise the IFERROR statement in the outside pair of brackets will come into play and result in a blank cell.

Upvotes: 2

Related Questions