In Sub-Summary,
Put this in B2:
=INDEX('Data Entry'!$B$2:$E$7,MATCH($A2,'Data Entry'!$A$2:$A$7,0),MATCH(B$1,'Data Entry'!$B$1:$E$1,0))
Copy down
In Sub-Summary,
Put this in B2:
=INDEX('Data Entry'!$B$2:$E$7,MATCH($A2,'Data Entry'!$A$2:$A$7,0),MATCH(B$1,'Data Entry'!$B$1:$E$1,0))
Copy down
Last edited by Max, Singapore; 08-10-2012 at 11:00 AM.
Max
Singapore
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks