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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Weeks
[/TD]
[TD]Pounds
[/TD]
[TD]Season Type
[/TD]
[TD][/TD]
[TD]Low
[/TD]
[TD]Normal
[/TD]
[TD]Super
[/TD]
[TD]4th
[/TD]
[TD]Cinco
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]27
[/TD]
[TD]10K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]27
[/TD]
[TD]29
[/TD]
[TD]34
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]28
[/TD]
[TD]12K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]28
[/TD]
[TD]30
[/TD]
[TD]35
[/TD]
[TD]37
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]29
[/TD]
[TD]13K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]31
[/TD]
[TD][/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]30
[/TD]
[TD]14K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]32
[/TD]
[TD][/TD]
[TD]39
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]31
[/TD]
[TD]25K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]33
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]32
[/TD]
[TD]2k
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]33
[/TD]
[TD]7K
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.