Enter into the AS sheet for Finish:
=VLOOKUP(AS!Axx,'Prog dump'!A:L,7,FALSE)
Where xx is the row number. Copy to the rest of the sheet.
The 7 in the above equation is the column index number Finish in 'Prog dump'. For the Budgeted Material Cost, it is 9. For Annual Total Cost, it is 10. Otherwise, the equations are identical.
|