Find value and return row header

How do you get 6 for the result? Shouldn't that be a 4?

Array enter this formula in K2:

Formula:

Please Login or Register  to view this content.

It produces this:

Row\Col	A	B	C	D	E	F	G	H	I	J	K
1	1	A1	B1	C1	D1	E1			Ref		Result
2	2	A2	B2	C2	D2	E2			C7		7
3	3	A3	B3	C3	D3	E3
4	4	A4	B4	C4	D4	E4
5	5	A5	B5	C5	D5	E5
6	6	A6	B6	C6	D6	E6
7	7	A7	B7	C7	D7	E7
8	8	A8	B8	C8	D8	E8
9	9	A9	B9	C9	D9	E9
10	10	A10	B10	C10	D10	E10
11

Array formulas must be committed by pressing Ctrl + Shift + Enter

Will do.

It works! Thank you so much!