Share via

ConcatenateIf

Anonymous
2018-02-28T01:24:37+00:00

I was fortunate enough to find the post from @HansV MVP and use it to create the function: concatenateif. It worked perfectly. However I do have one question, my criteria range includes columns in different worksheets. How can I fix the formula for it to take them into consideration and pulling the concatenate ranges. 

Let me clarify: 

=CONCATENATEIF(A1:A8, "a", B1:B8, "_")

I need to include in the first range, columns from other sheets, multiple sheets. 

I'm very grateful for anyone that can help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-02T07:36:39+00:00

    Hi Ccapiello,

    Have you checked Rosen's reply? Let us know if you need further assistance.

    Thanks,

    Tina

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-02-28T03:05:08+00:00

    Hi Ccapiello,

    Excel doesn't have the function of ConcatenateIf. Please refer to CONCATENATE function and IF function to know more about CONCATENATE.

    Also, please describe your requirement in detail, our community members and support team will help with you.

    Regards

    Rosen

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments