Lookup/ Match?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
Heading equalto that in Col 2 same row
 
Back
Top