Forum Discussion

kscott's avatar
kscott
Copper Contributor
Aug 07, 2017

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