Forum Discussion
Solved
How to lookup text in a string and return a value
I have circa 500 rows x 3 columns of data. The first column contains a text string with up to 20 words and a alphanumeric code. I want to lookup the codes from a table containing circa 600 codes and r...
Use wild card
=INDEX(Your3rdColumnValues MATCH("*"&YourCode&"*",YourColumnWithCodeMixed,0),1)
Use wild card
=INDEX(Your3rdColumnValues
MATCH("*"&YourCode&"*",YourColumnWithCodeMixed,0),1)
Thank you Juliano-Petrukio . I'll need to double check but it looks like you've got it in one. That's very kind of you. 👏😁