Hello
I have been used to writing single value VLOPUP funtions but having issue when there are multiple values to the same main condition
I have 2 TABS in excel
TAB 1 have client name and some values under it.. TAB2 has the client name and multiple people covering it.. Now if I write a VLOOKUP it only catching the firts name..
This is how the TABS are set
TAB 1
Client Name Cleint ID $ Value
ssss 12536 10
TAB 2
Client Name Covering person
ssss John
ssss mike
I have 100's of clients and covering person
I have to add a VLOOPUP formaul in TAB1 which added the covering people next to the client name
Client Name Cleint ID $ Value Covering person
ssss 12536 10 John, Mike
I appreacite your help
Thanks
I have been used to writing single value VLOPUP funtions but having issue when there are multiple values to the same main condition
I have 2 TABS in excel
TAB 1 have client name and some values under it.. TAB2 has the client name and multiple people covering it.. Now if I write a VLOOKUP it only catching the firts name..
This is how the TABS are set
TAB 1
Client Name Cleint ID $ Value
ssss 12536 10
TAB 2
Client Name Covering person
ssss John
ssss mike
I have 100's of clients and covering person
I have to add a VLOOPUP formaul in TAB1 which added the covering people next to the client name
Client Name Cleint ID $ Value Covering person
ssss 12536 10 John, Mike
I appreacite your help
Thanks