Searching a column for any partial matches from another cell text

[greg93]

Hi all,

Hopefully I can make this make sense,

In cell A1 I want a formula that would search column C for a partial match with any text currently in B1

So B1 shows car and one of the cells in column C contains Car Allowance this should return into cell A1

Any help would be great
Thanks

 

[Joe4]

Maybe use the FILTER function.

Here is an example:

and here is the formula in cell A1:

=FILTER(C1:C4,ISNUMBER(SEARCH($B$1,C1:C4)))

 

[felixstraube]

How about:
If you don't want case sensitivity replace FIND with SEARCH

Libro1
	A	B	C
1	Another car	car	Car 1
2			Car 2
3			OtherVehicle1
4			OtherVehicle2
5			Car 3
6			Another car
Hoja1

Cell Formulas
Range	Formula
A1	A1	=FILTER(C1:C1000, ISNUMBER(FIND(B1,C1:C1000)))

 

[greg93]

Thank you both! These were great and exactly what I needed

 

[Joe4]

You are welcome.
Glad we were able to help!