Hello all,
I have two sheets in same workbook. There is PIVOT table in first and ordinary table in second. In both tables are some players with some data. Players in ordinary table are Subset of PIVOT table. It means that all players which are in Ordinary table are also in PIVOT but all players from PIVOT are not in ordinary.
Now, I need to add column in ordinary table with associated data from PIVOT. Excel must go in each row (each player) in ordinary table, then found associated data for that player in PIVOT.
Thank you in advance.
I have two sheets in same workbook. There is PIVOT table in first and ordinary table in second. In both tables are some players with some data. Players in ordinary table are Subset of PIVOT table. It means that all players which are in Ordinary table are also in PIVOT but all players from PIVOT are not in ordinary.
Now, I need to add column in ordinary table with associated data from PIVOT. Excel must go in each row (each player) in ordinary table, then found associated data for that player in PIVOT.
Thank you in advance.