Hello, excel forum
I am trying to insert a number of rules within a newly created spreadsheet.
I am a novice when it comes to using formulas so I would be most graeful if someone could help me with the below.
- I have a workbook with all my price data. This includes average hotel room rates, flight costs, resource costs, job role, project location, project resource location etc
- I would like to create an input workbook that can be completed by members of staff so we can estimate project costs. THis would be built up of pick lists, manual fields, calculated fields and rules.
- I would like to add rules that insert the correct value (from the price data workbook) when certain rules are met
- One rule is 'If Job role = Consultant and Project Resource location = London then show correct day rate from price data workbook. I have a number of different permutations that need to be included in this rule
- Another example is if Project Location = Kuwait and Project Resource location = London then find the correct flight cost value (from data workbook x cell xx).
Apologies if Im alittle vague but I have attached an example document
Thanks in advance for your help
Bookmarks