Hi,
I have attached a sample costing sheet where I am attempting to use dependent drop down lists within a table. I have managed to create these and I am quite please with how they function. The next part is what I am struggling with, I am unable to automatically populate the 'cost per unit' and 'cost per weight' cells based on the selections from the data validation lists.
if anyone could suggest a formula that would work it would be greatly appreciated.
Cheers, Matt.
(I've never posted on here before so I'm hoping I've done everything correctly, hopefully there should be a spreadsheet attached..)
Bookmarks