wedd
11-08-2010, 12:48 AM
I have a spreadsheet with these different algorithms or in excel terms lookups. Can a excel expert explain to me what each of these 5 algorithms mean? Thanks for your answers.
(A)
='11. Soil Graphs'!'01. Raw Data'!'11. Soil Graphs'! Schedule '11. Soil Graphs'!G3+'11. Soil Graphs'!Q4
(b)
=SUMPRODUCT(N(CAP_AREA='09. Capacity Table'!$B$2),N(CAP_MONTH='09. Capacity Table'!D$6),N(CAP_ACT=$B8),CAP_PLAN)
(c)
='07. Schedule Database'!
(D)
=VLOOKUP($D2,'J:\Documents and Settings\tony.wager\Local Settings\Temporary Internet Files\OLK16\[FRC Staff Register 210208 v2.xls]Lookup 2'!$A$2:$H$372,7)
(E)
=IF(VLOOKUP($BK40,Andy,MATCH(BS$7, AndyHead,0), FALSE)<> 0, VLOOKUP($BK40,Andy,MATCH(BS$7, AndyHead,0), FALSE),IF(VLOOKUP($BK40,Margaret,MATCH(BS$7, MargaretHead)
:friends:
(A)
='11. Soil Graphs'!'01. Raw Data'!'11. Soil Graphs'! Schedule '11. Soil Graphs'!G3+'11. Soil Graphs'!Q4
(b)
=SUMPRODUCT(N(CAP_AREA='09. Capacity Table'!$B$2),N(CAP_MONTH='09. Capacity Table'!D$6),N(CAP_ACT=$B8),CAP_PLAN)
(c)
='07. Schedule Database'!
(D)
=VLOOKUP($D2,'J:\Documents and Settings\tony.wager\Local Settings\Temporary Internet Files\OLK16\[FRC Staff Register 210208 v2.xls]Lookup 2'!$A$2:$H$372,7)
(E)
=IF(VLOOKUP($BK40,Andy,MATCH(BS$7, AndyHead,0), FALSE)<> 0, VLOOKUP($BK40,Andy,MATCH(BS$7, AndyHead,0), FALSE),IF(VLOOKUP($BK40,Margaret,MATCH(BS$7, MargaretHead)
:friends: