Posted by Dan on December 07, 1999 5:28 PM
I'm looking for something like
Ideally I'd like to do something like =CONCATENATE(IF(A:A="apple",B:B)
I've read and, for the most part, understand CSE functions and those seem to work great on things that return a single value. I'm not sure if they apply here.
Thanks in advanced.