Hi Folks,
Sheet 1 has values listed as below
Suppl1 1 INV100
suppl1 1 INV101
Suppl2 2 INV777
Sheet 2 i would like to derive a lookup / match to get results as below
1 INV100,INV101
2 INV777
I tried using vlookup, but it list only one value. Someone can help?
Regards
Hari
Bookmarks