Hi,
I attached a file with example of what I'm looking for.
1. Sheet "Full Name" contain full strings.
2. Sheet. "Name" contains strings which are parts of the strings from sheet "Full Name".
3. For each cell in sheet "Name" I want to find and return the corresponding full-string from sheet "Full Name".
Thanks in advance.
First make sure that the Names column in the Name sheet are texts. Then, in B2 enter this:
=INDEX(Table1[Full Names],MATCH(TRUE,ISNUMBER(SEARCH([@Names],Table1[Full Names])),0))
But be aware that it only returns the first match it finds. So, if you would also have a full name "885H" below "H 885" only "H 885" will be returned for both "885" and "H".
File attached.
Dear Riny,
It worked!
It took me some strugling to apply it to my document, which has slightly more data,
but after some more understanding of the "SEARCH" function, it did the job.
Thank you so very much.