Hi All,
I'm beyond frustrated trying to get multiple text values to appear in single cell. This is the formula I have at the moment and the goal is to return the audit name, which it will do but only if all conditions are met and for one single audit name.
So C4:C2000 contains the audit names. To return the specific ones I want it must match 4 conditions: "ACCO", "Internal", "Complete" and the final is to a cell with the month name "January" because I want this to be the only input required. Is there an additional function I can add that will add ALL audit names that meet these requirements into the single cell I have it in (perhaps delimited by
?
Really Appreciate any help,
K
I'm beyond frustrated trying to get multiple text values to appear in single cell. This is the formula I have at the moment and the goal is to return the audit name, which it will do but only if all conditions are met and for one single audit name.
Code:
=INDEX('Master Audit-IR Tracker'!C4:C2000,MATCH(1,('Master Audit-IR Tracker'!A4:A2000="ACCO")*('Master Audit-IR Tracker'!D4:D2000="Internal")*('Master Audit-IR Tracker'!E4:E2000="Complete")*('Master Audit-IR Tracker'!K4:K2000='Audit-IR Output'!L9),0))So C4:C2000 contains the audit names. To return the specific ones I want it must match 4 conditions: "ACCO", "Internal", "Complete" and the final is to a cell with the month name "January" because I want this to be the only input required. Is there an additional function I can add that will add ALL audit names that meet these requirements into the single cell I have it in (perhaps delimited by
? Really Appreciate any help,
K
