Need help to find all values of a column in another column

[rajtak]

Please see the screenshot below and suggest any formula. Thank you in advance.

 

[Sandeep Warrier]

Hi

Try

Excel Workbook
	A	B	C
1	RL	XX ABAD HKLJ RL XXXX	RL
2	AL	XX RL ABAD HKLJ XXXX	RL
3	HL	XX SSSS XXXX ML AAAAA	ML
4	ML	BBBBB XXX HL XXXX SSSS	HL
Sheet3

Excel 2010

Cell Formulas
Range	Formula
C1	=LOOKUP(9.9999E+307,SEARCH($A$1:$A$4,B1),$A$1:$A$4)

 

[rajtak]

Hi Sandeep, ThanQ, it worked perfectly.