Merging data without VLOOKUP

[Pierre640]

Hello,

I have an issue with Excel, I have to merge data but I can't use VLOOKUP because it's not showing duplicates.

Here is the data I have:

EXG	STB	SSS	STB
EXG_SSI_1500	STB_SSI_01300	SSS_TEST_00802	STB_SSI_01300
EXG_SSI_1500	STB_SSI_01490	SSS_TEST_00470	STB_SSI_01670
EXG_SSI_1650	STB_SSI_01470	SSS_TEST_00471	STB_SSI_01670
EXG_SSI_1655	STB_SSI_01470	SSS_TEST_00802	STB_SSI_01000
EXG_SSI_1500	STB_SSI_01270	SSS_TEST_00472	STB_SSI_01270
EXG_SSI_1001	STB_SSI_01670	SSS_TEST_00802	STB_SSI_01200

And here is what I'd like to have.

EXG	STB	SSS
EXG_SSI_1500	STB_SSI_01300	SSS_TEST_00802
EXG_SSI_1001	STB_SSI_01670	SSS_TEST_00470
EXG_SSI_1001	STB_SSI_01670	SSS_TEST_00471
	STB_SSI_01000	SSS_TEST_00802
EXG_SSI_1500	STB_SSI_01270	SSS_TEST_00472
	STB_SSI_01200	SSS_TEST_00802
EXG_SSI_1500	STB_SSI_01490
EXG_SSI_1650	STB_SSI_01470
EXG_SSI_1655	STB_SSI_01470

Thx !

[#2]

If I try XLOOKUP, here is the result:

EXG_SSI_1500	STB_SSI_01300	SSS_TEST_00802
EXG_SSI_1001	STB_SSI_01670	SSS_TEST_00470
EXG_SSI_1001	STB_SSI_01670	SSS_TEST_00471
0	STB_SSI_01000	SSS_TEST_00802
EXG_SSI_1500	STB_SSI_01270	SSS_TEST_00472
0	STB_SSI_01200	SSS_TEST_00802
EXG_SSI_1500	STB_SSI_01490
EXG_SSI_1650	STB_SSI_01470
EXG_SSI_1650	STB_SSI_01470

The last one should be EXG_SSI_1655 and not 1650...

Any idea ?

Thanks !