PDA

View Full Version : Formulas help



tommyl18
02-04-2014, 03:02 AM
Hi Please help me create some formulas to get my excel sheet working

I have attached the workbook with all the details inside thanks in advance

Bob Phillips
02-04-2014, 07:07 AM
How do materials relate to the job? You can't put them in a delimited list like you do (well you could, but it makes hard and you would have no validation of input).

tommyl18
02-04-2014, 02:03 PM
The labour and materials make up the total cost of the job. The labour is based on an hourly rate and the materials are broke down into individual units

tommyl18
02-04-2014, 02:05 PM
Im not sure the best way to lay the table out so any advice welcome

Aussiebear
02-04-2014, 03:49 PM
Try the following workbook. I set up your Material/Labour as a table on Sheet 2 and simply used a Vlookup to find the costs per unit on Sheet 1