Forum

Notifications
Clear all

Find and Combine

3 Posts
2 Users
0 Reactions
78 Views
(@Anonymous)
Posts: 0
New Member Guest
 

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.

 
Posted : 26/01/2023 7:23 am
Riny van Eekelen
(@riny)
Posts: 1217
Member Moderator
 

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.

 
Posted : 26/01/2023 7:57 am
(@Anonymous)
Posts: 0
New Member Guest
 

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.

 
Posted : 28/01/2023 7:00 am
Share: