What do each of these VLookups mean?

[wedd]

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)

[Bob Phillips]

A and C look odd to me, but B is a simple conditional sum, D is a simple IF on a VLOOKUP that does a different VLOOKUP if the result is 0.