Power Query
October 7, 2021
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.
Trusted Members
Moderators
January 31, 2022
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.
1 Guest(s)