Hi there,
Will try to explain this as best as possible.
On worksheet "Estimate" I have dropdown menus to select from different resources (dropdown menu starts in F5 to F16). If I select John Smith from the drop down menu the data populates beside it showing that persons hourly rate, from there I assign the amount of hours I need that person for which shows the total cost in cell K5 through to K16.
On the worksheet named "Lists" I have all the information that feeds my dropdown menus. I have this information reflecting as follows:
Name - I2
Hourly Rate - J2
Task (whether they are full time or contract) - K2
Department - L2
The above list ranges from I2 to L47
I need a formula that will look in the name field for the "Estimate" worksheet that sees the resources department from the "Lists" worksheet that starts on L2 and down to L47 and assign that cost that is reflected in cell K5 through K16 on the worksheet "Estimate" to a total department cost that shows in cell C57.
I basically need the formula to say "ok so this resource works in the development department so I will take his total cost and add it to cell C57"
I'm sure none of this makes sense. I would love to add images but for the life of me I cannot figure out how to post images in this forum.
Thanks!
Will try to explain this as best as possible.
On worksheet "Estimate" I have dropdown menus to select from different resources (dropdown menu starts in F5 to F16). If I select John Smith from the drop down menu the data populates beside it showing that persons hourly rate, from there I assign the amount of hours I need that person for which shows the total cost in cell K5 through to K16.
On the worksheet named "Lists" I have all the information that feeds my dropdown menus. I have this information reflecting as follows:
Name - I2
Hourly Rate - J2
Task (whether they are full time or contract) - K2
Department - L2
The above list ranges from I2 to L47
I need a formula that will look in the name field for the "Estimate" worksheet that sees the resources department from the "Lists" worksheet that starts on L2 and down to L47 and assign that cost that is reflected in cell K5 through K16 on the worksheet "Estimate" to a total department cost that shows in cell C57.
I basically need the formula to say "ok so this resource works in the development department so I will take his total cost and add it to cell C57"
I'm sure none of this makes sense. I would love to add images but for the life of me I cannot figure out how to post images in this forum.
Thanks!
Last edited:
