Multiple Criteria Lookup Results
Although it looks complex, if it is sparsely used, this is not that
expensive a formula.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Forgone" wrote in message
...
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=VALU E(BFund))*(O9B.CCC=$C166)*,0))=0,"",
INDEX(O9B.Comments,
MATCH(1,(O9B.CCB=VALUE(BCostCentre))*(O9B.CCD=VALU E(BFund))*(O9B.CCC=$C166)*,0))))
|