Trying to return Cell from Column that Matches Data Range

[hammerhead13]

I need a Formula that will find the Number in the Range D5:H8 and return a Name from Column C. For Example. If i Put "61" I want it to Return "Bill". Thanks in Advance.

	C	D	E	F	G	H
5	Bob	10	2	54	24	3
6	Bill	15	61	64	7	63
7	Ted	123	90	67	43	23
8	Fred	23	65	22	53	42

 

[DanteAmor]

How about:

vDante Amor
	C	D	E	F	G	H	I	J	K
4								Number	Name
5	Bob	10	2	54	24	3		61	Bill
6	Bill	15	61	64	7	63
7	Ted	123	90	67	43	23
8	Fred	23	65	22	53	42
Hoja3

Cell Formulas
Range	Formula
K5	K5	=INDEX($C$5:$C$8,SUMPRODUCT(LARGE(($D$5:$H$8=J5)*ROW($C$5:$C$8),1))-4)

 

[hammerhead13]

How about:

vDante Amor
	C	D	E	F	G	H	I	J	K
4								Number	Name
5	Bob	10	2	54	24	3		61	Bill
6	Bill	15	61	64	7	63
7	Ted	123	90	67	43	23
8	Fred	23	65	22	53	42
Hoja3

Cell Formulas
Range	Formula
K5	K5	=INDEX($C$5:$C$8,SUMPRODUCT(LARGE(($D$5:$H$8=J5)*ROW($C$5:$C$8),1))-4)

Brilliant. Worked Perfectly! Thank you!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.