Excel VBA: CONCATENATE + IF/LOOKUP

**amq** · 08-28-2012, 07:32 AM

Hi there,

not having found a suitable set of excel formulas solving my issue ad-hoc, I went ahead looking into Macros. This is what I want to do:

- CONCATENATE a set of fields in one column
- IF the field in the colum left of my text-field matches a certain criteria

Basically replicating the checking functionality of SUMIF, just with concatenate.

I have found relevant VBA-snippets that I have tried to combine. However, I am lacking the criteria-checking functionality. Here is what I got:

Please Login or Register  to view this content.

This naturally does't work, as I am not checking the correct cCell value (second IF-Check).

Hence my question: How can I get the correct cCell to check against in the game here?

Thank you for your help!

Best regards,
Andreas

**amq** · 08-28-2012, 08:17 AM

Hi,

helped myself.

This works:

Please Login or Register  to view this content.

It also eradicates duplicates. However, if there was a line-break (alt+return) in the textfield before it disappears in the result. Is there anything I can do to keep potential linebreaks?

Thank you.

Best regards,
Andreas