I need some help to find and match patterns of strings in a column and fetch data from the adjacent column. I've attached a sample workbook with my sample data.
How can I find the appropriate matching pattern and fetch and fill data from the adjacent column from my source table to destination? I tried the string functions available and used SEARCH function to match the pattern and check whether it is available. However, when the pattern is found, how can I fetch the adjacent column ?
My attempt to code a formula using SUBSTITUTE, MID and SEARCH functions made me stumble at a Frankenstein monster
Below is the monster formula I wrote - it works and returns 1 when the pattern is found.
I need to return the matching pattern that is found. And with it the corresponding adjacent cell's value. Can anyone help me ?Formula:Please Login or Register to view this content.
Bookmarks