Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match not working
I have data in one format:
Jan Feb CoA 10 20 CoB 30 40 I want to be able to do a lookup to get it to look like: CoA CoB Jan 10 30 Feb 20 40 I tried doing an index with embedded matches, but that didn't work -- Does anyone have any suggestions? I don't want to do a copy-paste values-transpose because it's going to be something I'm going to need to update on a daily basis and want to be able to trace back where my numbers are coming from. Any help would be appreciated. thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index and match? | Excel Discussion (Misc queries) | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Index/Match not working | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |