Hi:
Attached file has two tabs. one is the pivot table (i copy paste the pivot from original file since it was too big) and on the ohter tab, i try to put formula on col M to match Col I and C from pivot, but somehow it doesn't work. please help
Hi:
Attached file has two tabs. one is the pivot table (i copy paste the pivot from original file since it was too big) and on the ohter tab, i try to put formula on col M to match Col I and C from pivot, but somehow it doesn't work. please help
Last edited by turbo600hp; 12-27-2013 at 04:56 PM.
Put this formula in M2 of the GrossUp sheet:
=IFERROR(INDEX('Summary Pivot'!$B$3:$L$15, MATCH($I2,'Summary Pivot'!$A$3:$A$15,0),MATCH($C2,'Summary Pivot'!$B$2:$L$2,0)),"")
then copy it down as required - you will get blanks if there is no match on a particular row.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks