Forum Discussion
How to Match Certain Char and Return a Value from another Table based on the Matched Char?
You may try something like this...
Unmerge the cell B4 and then try this...
In B4
=LOOKUP(2,1/(ISNUMBER(SEARCH(TRIM(Table1[[Clean Code ]]),Table2[@CODE]))),Table1[Value])
and then copy it down.
Let me know if this is what you were trying to achieve.
Why not upload a small sample file with some dummy data along with the desired output mocked up manually to show the end result you are trying to achieve? That would help to visualize the desired output and to provide an accurate solution.
Thank you very much for your response. I have just updated the thread with a file. Please, have a look.
You may try something like this...
Unmerge the cell B4 and then try this...
In B4
=LOOKUP(2,1/(ISNUMBER(SEARCH(TRIM(Table1[[Clean Code ]]),Table2[@CODE]))),Table1[Value])
and then copy it down.
Let me know if this is what you were trying to achieve.
Thank you very much, it does work perfectly. Could you please re-write the formula using cell references instead of column names?
Thank You--
You're welcome! Glad it worked as desired.
Here is the requested formula...
=LOOKUP(2,1/(ISNUMBER(SEARCH(TRIM($F$4:$F$6),A4))),$G$4:$G$6)