Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Excel Help with Formula =IF(ISERROR

Jan 21, 2015 1:03AM PST

I have a formula I need some assistance with. What I am trying to achieve is to check if the text in Cell A appears anywhere within the Cell C Column, if the text does appear then I want excel to print the data from the matching Cell C.
What I have so far is;

=IF(ISERROR(MATCH("*"&A3&"*",$C$2:$C$8,0)),"",A3)

Now this formula does what I want but it prints the contents of Cell A, it is not simply a case of changing it to Cell C as that won't print the matching cell.

I'm sure this is something simple and thankyou in advance for your responses.

Discussion is locked