Hi all,

First time posting so thanks for your help in advance! I am trying to merge individual level data with group level data. For example, I have a team ID on one sheet with about 20 columns of data and multiple individuals that are part of that team on another sheet. The only way to match the groups to the individuals is with the group ID.

In other words, I am trying to match values in two different columns, then copy the value in column B and about 20 columns worth of data to the right of column B next to the matched value in column A. But here's the catch, there are multiple identical values in column A (representing the different individuals within the team) and I want to match and copy the same 20 columns worth of data to each of the matched values. It's not simply the case that I want to copy one cell or column worth of data when I find a matched value, I need to copy multiple columns worth of data for each matched value and there will be multiple matched values.

So here is a simple example of what my data look like. Columns A:D are on one sheet and columns G:J are on another sheet. I put "XX" to indicate important data that I will need to keep grouped:


A1:XX B1:XX C1:XX D1:SHAL G1:SHAL H1:XX I:XX J1:XX
A2:XX B2:XX C2:XX D2:SHAL G2:SING H2:XX I:XX J2:XX
A3:XX B3:XX C3:XX D3:SHAL G3:SITA H3:XX I:XX J3:XX
A4:XX B4:XX C4:XX D4:SING
A5:XX B5:XX C5:XX D5:SING
A6:XX B6:XX C6:XX D6:SITA
A7:XX B7:XX C7:XX D7:SITA

In this example, I need to match G1 to all the matched values in column D and then copy G1:J1 next to the matched values in column D.

Does that make sense? I really appreciate any advice you can provide. Is there a way to do this using basic excel only? I do not have experience with VB or macros.

Thanks!