Forum Discussion
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...
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.