Identifying Column for Match Function

[croeder]

How do I tell a match function to look in a certain row for data?

For example

1221 23 89
2213 81 22
9901 77 91

I want to be able to tell match to search the row with 2213 in it so I can determine which position or column 22 is in.

Thank you for the help!

 

[Steve=True]

you need to use a combo index and match formula.

http://www.contextures.com/xlfunctions03.html

http://support.microsoft.com/kb/214142

 

[Aladin Akyurek]

How do I tell a match function to look in a certain row for data?

For example

1221 23 89
2213 81 22
9901 77 91

I want to be able to tell match to search the row with 2213 in it so I can determine which position or column 22 is in.

Thank you for the help!

Let A2:D4 house the sample.

E2: 2213

F2: 22

G2:

=MATCH(F2,INDEX($A$2:$C$4,MATCH(E2,$A$2:$A$4,0),0),0)

This should return 3, a position value with respect to A2:D4.

 

[T. Valko]

How do I tell a match function to look in a certain row for data?

For example

1221 23 89
2213 81 22
9901 77 91

I want to be able to tell match to search the row with 2213 in it so I can determine which position or column 22 is in.

Thank you for the help!

What result do you expect, 2 or 3?

This will return 2.

Book1
	A	B	C	D	E
2	1221	23	89	_	2213
3	2213	81	22	_	22
4	9901	77	91	_	2
Sheet1

Formula entered in E4:

=MATCH(E3,INDEX(B2:C4,MATCH(E2,A2:A4,0),0),0)

 

[croeder]

Thank you both for the responses, much appreciated.

 

[Aladin Akyurek]

Thank you both for the responses, much appreciated.

You are welcome. Thanks for providing feedback.

 

[T. Valko]

Thank you both for the responses, much appreciated.

You're welcome. Thanks for the feedback!