Multiple Criteria Lookup Results
Bob,
Would this work using VBA in an effort to reduce the amount of time it
would take to process this equation?
On Jul 15, 5:30*pm, "Bob Phillips" wrote:
Maybe
=IF(ISERROR(INDEX(O9B.Comments,
* * * MATCH(1,(O9B.CCB=VALUE(BCostCentre))*(O9B.CCD=VALU E(BFund))*(O9B.CCC=$C166)*,0))),"",
* * * IF(INDEX(O9B.Comments,
* * * * * *MATCH(1,(O9B.CCB=VALUE(BCostCentre))*(O9B.CCD=VAL UE(BFund))*(O9B.CCC=$C166)*,0))=0,"",
* * * * * *INDEX(O9B.Comments,
* * * * * *MATCH(1,(O9B.CCB=VALUE(BCostCentre))*(O9B.CCD=VAL UE(BFund))*(O9B.CCC=$C166)*,0))))
|