I need to use vLookup formula in Column 3 to get the Column 1 data in Column3. Please note that the column 2 data patterns are dynamic. I have provided some sample patterns for your understanding. Can anyone help me to find the dynamic vlookup formula to handle all such patterns?
|Column 1 | Column 2 | Column 3 |
|10-111-222-55 | 10-111-222-55.abc.test.com | 10-111-222-55 |
|10-111-222-55 | abc.test.com.10-111-222-55 | 10-111-222-55 |
|10-111-222-55 | 10-111-222-55\abc.test.com | 10-111-222-55 |
|abcd1234 | abcd1234 | abcd1234 |
|xyz | abc_telecom\xyz | xyz |
|abc | abc.API.com | abc |