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...
Detlef_Lewin
Aug 07, 2017Silver Contributor
kscott,
=TEXTJOIN(", ",TRUE,IF(C1:C17="ardvark",A1:A17,""))