Log In
Register
Home
Power Query
October 7, 2021
Offline
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
Offline
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.
Power Query
October 7, 2021
Offline
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.
1 Guest(s)
