Find some cell's text in another column and get the text of those cells

For instance,

In B:B a list of several cells each one with some text, in this case are all made of 3 contiguous alpha-numeric characters like "AAA", "ACD", "B0W", etc.
In A:A a list of several cells containing different kind of alphanumeric text with different number of charachters, they may be whatever ("1 asD", "0AAA","fu hi 04532").

I am searching some kind of formula to put in C1 and drag-down to get in C an answer giving me the text of those cells in A:A matching this search, i.e. those cells whose text included some part where there was, say "AAA".

Quotations "" are not in the data set.
Thanks for any help,

Simone

not sure if I understand correct but try something like

If(and(contain(text),
Text2,"display value/null" )

see if it works

Hi nicci113,

Thanks for answering. I am looking for a kind of VLOOKUP because I need to look for, say, the B2 text, in all the A column cells and get dispayed all the texts (entire cells) in A that matched that searching.
Hope this makes thinks clearer than before.

Thnaks again

could you please give a sample data what it looks like? There are 2 condition in my earlier reply, you can change it to single comparison as well

Hi,

Here it is the sample data. In C and D I have put two alternatives of how I would like to get the response: with the texts displayed or, if it is simpler to do, with the numbers of rows containing that text.
Hope it is feasible.

cant think of the sol since their is no standard format in col A. I'm doing some more example and will let you if I come accross something.