Lookup/ Match?

[Sachin]

Hi

Column 2 of my sheet contains codes A to
(based on items in column 1

Columns I to AH contain headings A to

In Col 3 I want is to extract the value from Column with Heading equalto that in Col 2 same ro

Ex

Col 2 Col 3 A B C D E F
A 1 2 4 8 16 32 6
B 4 2 4 8 16 32 64 12
C 3 6 12 24 48 96 19
D 32 4 8 16 32 64 128 25
E 5 10 20 40 80 160 32
F 192 6 12 24 48 96 192 38
G 7 14 28 56 112 224 44

Please Hel
Regard

Sachin

 

[Frank Kabel]

Hi
if row 1 storess your heading enter the following in C2
=INDEX(I2:AH2,MATCH(B2,$I$2:$AH$2,0))
and copy down

Regards
Frank Kabel

-----Original Message-----
Hi!

Column 2 of my sheet contains codes A to Z
(based on items in column 1)

Columns I to AH contain headings A to Z

In Col 3 I want is to extract the value from Column with

Heading equalto that in Col 2 same row

 

[Sachin]

Perfect

Than
Sachin

 

[Sachin]

Was it the second row? $I$2:$AH$

=INDEX(I2:AH2,MATCH(B2,$I$2:$AH$2,0)

Regard
Sachin

 

[Frank Kabel]

Hi
sorry should have been:
=INDEX(I2:AH2,MATCH(B2,$I$1:$AH$1,0))