Apr 21 2021 03:18 AM
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 !
Apr 26 2021 05:29 AM
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 !