Hello,

I am new here and I'm hoping one or some of you might be able to help me with this challenging task I have been given.

I have been charged with creating a sheet for work, it's function is to provide accurate costings for a job but also create a list of parts in that job based on what items are selected to be used. I will try to give an example below.

1. On sheet 1 I use drop down lists to select certain items.
2. Once selected, a cell to the right populates a price.
3. On another sheet, a part number, description and quantity are populated.
4. As I progress through sheet 1, it adds more costs and also populates the parts list so I know what items I need to do the job.
5. On another sheet is a massive table with all the parts, SKU, description, quantity needed, quantity in stock and so on.

I believe I need to use LOOKUP, VLOOKUP and SUMIFS to complete this but it is a little over my head.

Any help or guidance is appreciated.