Help with Index

[maximillianrg]

Hello Excel Masters

The below formula works perfectly and returns either a blank cell or a date

=IF(ISNA(INDEX(RawCu!K:K,MATCH(1,("54-Complete-Billing Review"=RawCu!E:E)*(C5=RawCu!B:B),0))),"",INDEX(RawCu!K:K,MATCH(1,("54-Complete-Billing Review"=RawCu!E:E)*(C5=RawCu!B:B),0)))

The above formula looks the string "54-Complete-Billing Review" in column E. I now need to modify the formula so that if it finds either "54-Complete-Billing Review" or "55-foo" on column E it returns the value the original formula does

Any ideas?

 

[Marcelo Branco]

To use an OR condition in an array formula you should add the two conditions. So see if this works in your case

...MATCH(1,(("54-Complete-Billing Review"=RawCu!E$1:E$1000)+("55-foo"=RawCu!E$1:E$1000))*(C5=RawCu!B$1:B$$1000),0)...

Note: for the sake of performance avoid references to entire columns, like K:K, E:E or B:B, in array formulas. Try definite ranges, E1:E1000, B1:B1000 etc, for example.

M.

 

[Marcelo Branco]

Instead of
=IF(ISNA(formula),"",formula)

Try
=IFERROR(formula,"")

M.