Hi Team,
I want to apply vlookup and get matching value.
But if there are duplicate matching value I want to show all by using Seperator.
Below is a Table
Input Column A and B.
with expected output Column E and F. how to achieve below task using dictionary or any other method.
Thanks
mg
I want to apply vlookup and get matching value.
But if there are duplicate matching value I want to show all by using Seperator.
Below is a Table
Input Column A and B.
with expected output Column E and F. how to achieve below task using dictionary or any other method.
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Name | Bank Ac Name | Expected Output:=> | Name | Bank Ac Name | |||
2 | Sachin | SBI | Sachin | SBI/HDFC | ||||
3 | Dhoni | SBI | Dhoni | SBI/JP Morgan | ||||
4 | Sachin | HDFC | Sachin | SBI/HDFC | ||||
5 | Kohli | ICICI | Kohli | ICICI/SWISS/Bank of America | ||||
6 | Gayle | SWISS | Gayle | SWISS | ||||
7 | Peterson | HSBC | Peterson | HSBC | ||||
8 | Ponting | Bank of America | Ponting | Bank of America | ||||
9 | Dhoni | JP Morgan | Dhoni | SBI/JP Morgan | ||||
10 | Jaysurya | Bank of China | Jaysurya | Bank of China/HSBC | ||||
11 | Jaysurya | HSBC | Jaysurya | Bank of China/HSBC | ||||
12 | Kohli | SWISS | Kohli | ICICI/SWISS/Bank of America | ||||
13 | Kohli | Bank of America | Kohli | ICICI/SWISS/Bank of America | ||||
Sheet1 |
Thanks
mg