Help with Lookup Function

[Thomas_85]

Hi guys,

I was hopeful someone could help me out with a Lookup function (IndexMatch, Vlookup, or Hlookup) for the following data.

The objective is to look up what is in column A (Weeks) and find its match in the array F2-I8, and bring the value E1-I1 into column C.

	A	B	C	D	E	F	G	H	I
1	Weeks	Pounds	Season Type		Low	Normal	Super	4th	Cinco
2	27	10K				27	29	34	36
3	28	12K				28	30	35	37
4	29	13K					31		38
5	30	14K					32		39
6	31	25K					33
7	32	2k
8	33	7K

<tbody>
</tbody>

Thanks a ton!!

 

[Marcelo Branco]

Try

C2 copied down
=INDEX(E$1:I$1,SUMPRODUCT(($E$2:$I$8=A2)*(COLUMN(E$1:I$1)-COLUMN(E$1)+1)))

M.

 

[Jonmo1]

Is that a truly realistic example?

Try
=LOOKUP(A2,$F$2:$I$2,$F$1:$I$1)

 

[Thomas_85]

Wow! Thanks Marcelo, it works great!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.