Hi,
I think i have a similar issue.
Currently i have data in this form:
Task (which is a drop down) Description (which vlookups from the task selection) Activity (either hi or low) and then proposed time.
The data is in a table in another tab,
Basically if you select the task the description populates using a vlookup, then the activity is either high or low, i want to then populate the proposed time by looking at the task and then the activity.
I could do an if statement but it would take ages to write as there are 20 different tasks and every proposed time is different, is there a way to do it?