Find partial text string within another text string return the full value

Hello,

I need your help pls.

First of all sorry for the level of my English.

In the excel document attached below i have in the column A the SKUs of products and in column B the filenames of the images.

Is it possible to partially match the value of A1 with the list of image filenames in column B and return in C the cells of B that contains the SKUs?

To be more clear

Screen Shot 2017-07-10 at 15.33.58 copy.jpg

Hello Andreas and Welcome to Excel Forum.
Use Glenn's Solution!

use this array formula in C1, copied across and down:

=IFERROR(INDEX($B:$B,SMALL(IF(ISNUMBER(SEARCH($A1,$B$1:$B$826)),ROW($B$1:$B$826)),COLUMNS($C1:C1))),"")

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

However, if you want the answers in a single cell (conveniently), you will need VBA. Are you OK with that?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.