View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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.