Index/Xmatch problem

[colelkay]

Hi, I am in a learning program and have run into a wall. When I type in the directions: Click INDEX in the Formula bar (Click OK if the argument list opens.) When I do this, it comes up wrong and shows invalid in red in the Arguments dialog box to the right of the row_num row. I have tried every scenario to try to find the right way. Help! I am in Excel 365 practice program. Thanks, Kay

 

[AhoyNC]

What are you inputing for the Row_num? It needs to be numeric.

 

[AhoyNC]

I see you have XMATCH in your header. So maybe something like this?

Book1
	A	B	C
1
2	Sam	l	Mike
3	Mike	p
4	Jane	o
Sheet5

Cell Formulas
Range	Formula
C2	C2	=INDEX(A2:A4,XMATCH("p",B2:B4),1)