Matching a character

[jollyn]

Hi Im new to excel I am trying to search for a character in cell A that matches list in column B and take that cell number to extract info of column C to E.
example:
To be redundant and make sure I make sense, Are any characters in Cell B match string in cell A row 1 Yes R in row 3 I need row 3 CELLC info to go to E.
CELL A CELL B. CELLC. CELL E
1 AAREAA M sdfldjjf R efggfd
2 BBMOBB X fffdjf M sdfldjjf
3 CXYCC R efggfd X fffdjf

Can someone point me in the right direction Ive tried Vlookup, also things like =if(REGEXMATCH(A25,c3),true,false) gives me true but its has be exact position but I would like any character in column B to be search in cell A1,A2... Thank you so much for the help.

 

[FormR]

Hi, welcome to the forum! Here's one option you can try with XL365.

Book3
	A	B	C	D	E
1	AAREAA	M	sdfldjjf	R	efggfd
2	BBMOBB	X	fffdjf	M	sdfldjjf
3	CXYCC	R	efggfd	X	fffdjf
4	MXR			M	sdfldjjf
5	RXM			M	sdfldjjf
Sheet1

Cell Formulas
Range	Formula
D1:D5	D1	=XLOOKUP(TRUE,ISNUMBER(FIND($B$1:$B$3,A1)),$B$1:$B$3,"")
E1:E5	E1	=XLOOKUP(TRUE,ISNUMBER(FIND($B$1:$B$3,A1)),$C$1:$C$3,"")

 

[jollyn]

Hi, welcome to the forum! Here's one option you can try with XL365.

Book3
	A	B	C	D	E
1	AAREAA	M	sdfldjjf	R	efggfd
2	BBMOBB	X	fffdjf	M	sdfldjjf
3	CXYCC	R	efggfd	X	fffdjf
4	MXR			M	sdfldjjf
5	RXM			M	sdfldjjf
Sheet1

Cell Formulas
Range	Formula
D1:D5	D1	=XLOOKUP(TRUE,ISNUMBER(FIND($B$1:$B$3,A1)),$B$1:$B$3,"")
E1:E5	E1	=XLOOKUP(TRUE,ISNUMBER(FIND($B$1:$B$3,A1)),$C$1:$C$3,"")

Thank you Guru FormR! Big Bow of Gratitude!