Excel Expert
Budget: £20 – £250 GBP
I need to create a spreadsheet based to automatically populate the cost of our products based on the manual inputs in other cells.
I have created a very basic "IF" function in the workbook already - please refer to the attached workbook. The data validation matches the information in the "All" sheet.
My ultimate goal is to select each one of the drop downs, which then populate the outputs as per the "IF" function, however, I would then like a cost to be automatically populated in the "yellow" cells based on those outputs.
I do have all of the costs in a separate workbook, however, these cost sheets can be added to the same workbook if necessary.
Please let me know if you can help me at all.
Thanks!
I have created a very basic "IF" function in the workbook already - please refer to the attached workbook. The data validation matches the information in the "All" sheet.
My ultimate goal is to select each one of the drop downs, which then populate the outputs as per the "IF" function, however, I would then like a cost to be automatically populated in the "yellow" cells based on those outputs.
I do have all of the costs in a separate workbook, however, these cost sheets can be added to the same workbook if necessary.
Please let me know if you can help me at all.
Thanks!