Forum Discussion
Solved
Find values from a table and transfer matches to another table
I need some help comparing 2 tables and pulling out the data I need. Currently we have a table of cost codes and all the users who are allowed to use them, I want to switch that and have a list ...
The comment that I used and that worked just fine was deleted for whatever reason so I'll put it here.
OliverScheurich said=TEXTJOIN("; ",,FILTER($A$3:$A$6,ISNUMBER(SEARCH(A10,$B$3:$B$6))))
This formula finds and combines the cost codes for each user. The formula is filled down from cell C10 in the example.
=BYROW(A10:A16,LAMBDA(x,TEXTJOIN("; ",,FILTER(A3:A6,ISNUMBER(SEARCH(x,B3:B6))))))
With Office 365 or Excel for the web you can apply this formula which spills the results. This formula is in cell D10 in the example.
I used the first formula and it would perfectly, saved me a lot of time, thank you.
The comment that I used and that worked just fine was deleted for whatever reason so I'll put it here.
OliverScheurich said
=TEXTJOIN("; ",,FILTER($A$3:$A$6,ISNUMBER(SEARCH(A10,$B$3:$B$6))))
This formula finds and combines the cost codes for each user. The formula is filled down from cell C10 in the example.
=BYROW(A10:A16,LAMBDA(x,TEXTJOIN("; ",,FILTER(A3:A6,ISNUMBER(SEARCH(x,B3:B6))))))
With Office 365 or Excel for the web you can apply this formula which spills the results. This formula is in cell D10 in the example.
I used the first formula and it would perfectly, saved me a lot of time, thank you.