Forum Discussion
votrava
Nov 29, 2022Copper Contributor
Help joining tables with one key and multiple repeating values on the other
Hello! I'm struggling to combine two sheets using the column of one as a key, and XLOOKUP is no help since the second sheet has multiple rows that match each of the key rows in the first. Sheet A...
OliverScheurich
Nov 29, 2022Gold Contributor
You can try Power Query. The worksheets "Sheet A" and "Sheet B" in the attached file contain blue dynamic tables where you can add data. The green table in the third worksheet is the result table. In order to refresh the query (after adding data) you can click in any cell of the green table and right-click with the mouse. Then select refresh.