LookUp/Match Question
 

My data table looks like so:

WFC UNG PBR RUT
1-Jun 3.04% 1.36% 0.85% 1.06%
2-Jun 2.38% 1.17% 1.42% 0.70%
3-Jun 3.27% 1.73% 1.29% 0.90%


I am looking for a formula for cells B2:D5 that will produce these results:

1-Jun 2-Jun 3-Jun
WFC 3.04% 2.38% 3.27%
UNG 1.36% 1.17% 1.73%
PBR 0.85% 1.42% 1.29%
IBM na na na


Thank you in advance.

LookUp/Match Question
 

I have your data table in A1:E4
So the text WFC is in B1, while 1-Jan is in A2, etc


Quote: I am looking for a formula for cells B2:D5 that will produce these
results
Not sure about B2:D5

I can get your result in A10:D15 with 1-Jan in B10 and text WFC in A11, etc
1-Jun 2-Jun 3-Jun
WFC 3.04% 2.38% 3.27%
UNG 1.36% 1.17% 1.73%
PBR 0.85% 1.42% 1.29%
IBM na na na

The formula that returns 3.04% in B11 (after I have formatted the cell for
%) is
=INDEX($B$2:$E$4,MATCH(B$10,$A$2:$A$4,0),MATCH($A1 1,$B$1:$E$1,0))

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"carl" wrote in message
...
My data table looks like so:

WFC UNG PBR RUT
1-Jun 3.04% 1.36% 0.85% 1.06%
2-Jun 2.38% 1.17% 1.42% 0.70%
3-Jun 3.27% 1.73% 1.29% 0.90%


I am looking for a formula for cells B2:D5 that will produce these
results:

1-Jun 2-Jun 3-Jun
WFC 3.04% 2.38% 3.27%
UNG 1.36% 1.17% 1.73%
PBR 0.85% 1.42% 1.29%
IBM na na na


Thank you in advance.