ExcelBanter - production cost

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - production cost (https://www.excelbanter.com/excel-worksheet-functions/93515-production-cost.html)

I am trying to make a form to track my production costs. How would I go
about making it so when I enter a part number, it autofills the costs it
makes to make it. We have over a thousand parts and I want to split
production into the cost of sanding and the cost of painting. Can you help???

I am not quite sure about your "FORM" is it built using VBA, excel cells or
others.
You can use vlookup/hllokup function to find the price for the part number
you enter.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================

"Ashsyme" wrote in message
...
I am trying to make a form to track my production costs. How would I go
about making it so when I enter a part number, it autofills the costs it
makes to make it. We have over a thousand parts and I want to split
production into the cost of sanding and the cost of painting. Can you
help???