Using "IF" to combine and merge unique data " , "

Hello!

I"m pretty confused. I'm having an issue with finding a way to merge data within cells. The function I'm trying to replicate would be the =join function in Google Sheet. I believe it's just a simpler =CONCATENATE. If possible I'd to come up with some "IF" formula I could scale. I'd like to use "IF" to see if the root/sub domains/email contacts (column B,C,D) match and if they do, combine all the simlar "source URLs" (Column A) in one text string in a different cell. I attached a picture below


Pic.jpg



Thanks in advanced,
Just another case of the mondays,

For clarification:

You're trying to match B, C, and D but it doesn't look as if any of them are the same.

Are you trying to see if B C or D strings are in the A strings?



Also, in Excel you can concatenate with "&" also.

Where A1 = pink, B1 = unicorn, C1 =A1&B1 will show pinkunicorn

Originally Posted by daffodil11

For clarification:

You're trying to match B, C, and D but it doesn't look as if any of them are the same.

Are you trying to see if B C or D strings are in the A strings?



Also, in Excel you can concatenate with "&" also.

Where A1 = pink, B1 = unicorn, C1 =A1&B1 will show pinkunicorn

I guess I phrased it wrong. I'm trying to match B & C, If they match than all the corresponding cells in column A (B2=C2 --> A2:A8) should be combined/merged in a different cell. The end goal is to combine all of cells in column A to one string that matches similiar numbers in B and C to an email in D. I hope that clarifies anything :/

I can try to explain further in images if that'd help

Originally Posted by RobertMika

A workbook with example would help better...

IB-linkdupetemp.zip

My apologies, I've attached the workbook that needs to be adjusted. I've highlighted an example in the table of what i'm trying to combine into one cell from columns based on the similarities in columns B and C.

Thanks for the all the help in advanced