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.
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)
Dear Subodh_Tiwari_sktneer,
Thank you very much, indeed. I truly appreciate it. You really really saved my day!! 🙂