• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help

D

danbuddy123

New Member
I have file name A "bill of material" with item Numbers and quantities. Then I have another file name B with costs for these item numbers.


How can I have file A look up costs in file B and them post them in file A so I can get a total cost for the bill of material?
 
Hi ,


Assume that your item numbers are in column A , and the corresponding quantities in column B. Assume that the list starts from A5.


Assume that your file B has a table with the item numbers in column A , and the corresponding costs in column B. Assume that the table starts from A5 and goes down till B279.


In your file A , in cell C5 , type in the following formula :


=B5*VLOOKUP(A5,[B.xlsm]Sheet1!$A$5:$B$279,2,FALSE)


This will use the item number in cell A5 ( in file A ) to lookup in the corresponding table in Sheet1 of file B.xlsm , and multiply the retrieved unit cost by the quantity ( in cell B5 of file A ) to get the total cost.


Copy this cell C5 to all other relevant cells in column C.


Instead of typing in the formula , you can open both files , and then create the formula by selecting the appropriate cells.


Narayan
 
You must log in or register to reply here.
Back
Top