Charlene Durand
Board Regular
- Joined
- Sep 19, 2015
- Messages
- 98
- Office Version
- 365
- Platform
- Windows
I have a excel time tracking. in this it has a projects tab this is where my dropdowns filter from when working on the timeLog tab
PROJECTS TAB
TIMELOG TAB
The formula in the dropdown for Service is in a data validation and this is the formula =OFFSET(taskIDlabel,MATCH(Client Name,taskIDList_ProjectID,0),0,COUNTIF(taskIDList_ProjectID,Client Name),1)
I am now trying to get the task drop down to look at the client name then the service, then give me the list of only what is for that.
is this possible
PROJECTS TAB
TIMELOG TAB
The formula in the dropdown for Service is in a data validation and this is the formula =OFFSET(taskIDlabel,MATCH(Client Name,taskIDList_ProjectID,0),0,COUNTIF(taskIDList_ProjectID,Client Name),1)
I am now trying to get the task drop down to look at the client name then the service, then give me the list of only what is for that.
is this possible