#1
|
|||
|
|||
Index, match in Pivottable and Pivotchart
Hello anyone.
I need help to solve this: I have 2 different PivotTable and PivotChart in the same worksheet. PivotChart has 2 column A and B, PivotTable has 2 column E and F. In column A has the same value or number with column F; my question: is there any Function, formula or macro to join, index or match if column A match with F so column B will match with E, then I can join to make a chart from Column B and E. Thank you very much in advance. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 AM |
Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
Vlookup or Index/Match - Multiple Criteria | ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Moving a Index/Match function | FraserKitchell | Excel | 2 | 01-19-2010 09:38 AM |