I want to want to learn excel formula or BV code where I will assign team members name in a table and in other table team remembers name will come as summary as attached image. enter image description here
I have tried “=IF(INDEX(Table2[GPQ],MATCH(J2,Table2[Team],0))=L2,INDEX(Table2[GPQ],MATCH(J2,Table2[Team],0)),””)” this excel formula but I’m getting only first name of the team members. 2nd or 3rd remembers not coming. Please help to solve
New contributor
Mahadi Hasan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.