LookUp/Match Question

[carl]

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 B25 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.

 

[Bernard Liengme]

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 B25 that will produce these
results
Not sure about B25

I can get your result in A1015 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($A11,$B$1:$E$1,0))

best wishes