View Single Post
 
Old 01-05-2015, 12:01 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote