LookUp/Match Question

C

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

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 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($A11,$B$1:$E$1,0))

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top