Apr 01 2022 01:30 PM
Hello,
I am hoping someone might be able to help me, I have data on sheet one that is in a table with headings. The first column contains a Cost Code, the fifth column contains a DFA number, I am trying to pull the data to a second reconciliation sheet. I have the reconciliation sheet set up to pull all of the information into the page based on the DFA number, the issue is that one DFA number can have multiple cost codes and I am having an issue getting the additional cost codes to pull in, all of the other information is pulling through correctly.
Any help or suggestions would be so appreciated!
Apr 01 2022 03:37 PM
Apr 01 2022 03:46 PM
=TEXTJOIN(", ",,FILTER(reconciliation!$A$2:$A$22,reconciliation!$E$2:$E$22='second reconciliation sheet'!E2))
If you work with Office365 or 2021 the above formula could do what you are looking for.