colA colB colc colD
1a 2b 1a
2b 3c 2b 2b
3c 4d 4d
4d 5e 5f 4d
Please help, what is function that I can use in colD that the value either in colB or colC match each other and if there is a match then the value is match will put in the same row of value in colA. example like 2b and 4d in colD
Thank you in advance
1a 2b 1a
2b 3c 2b 2b
3c 4d 4d
4d 5e 5f 4d
Please help, what is function that I can use in colD that the value either in colB or colC match each other and if there is a match then the value is match will put in the same row of value in colA. example like 2b and 4d in colD
Thank you in advance