Forum Discussion
kscott
Aug 07, 2017Copper Contributor
If Then for multiple cells fro a Newbie!
Morning All! Yes I'm A Newbie so I'm sure you've all seen this question before!
I'm looking to select a cell series (eg: C1:C17) to check for a term "ardvark". If ardvark is present in C1 I want the destinationcell to report A1", ". If not, then do nothing. Ardvark will be present in multiple cells so I will need multiple A values returnd in the destination cell with a ", " separator (eg: denning, nocturnal, habitat). If possible I'd like the last A value to not be followed by anything. Doable?
1 Reply
- Detlef_LewinSilver Contributor
kscott,
=TEXTJOIN(", ",TRUE,IF(C1:C17="ardvark",A1:A17,""))