Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP OR MATCH QUESTION PLEASE | Excel Discussion (Misc queries) | |||
LookUp/Match Question | Excel Worksheet Functions | |||
Match Lookup question | Excel Worksheet Functions | |||
A question for Match and Lookup | Excel Discussion (Misc queries) | |||
LookUp/Match Question | Excel Worksheet Functions |