How to use formula to capture and match item from a range of data?
I have this sheet that will record the various documents checklist for each client. The Client ID may repeat.
Whenever Doc 2 is completed, a staff will record the date in the Send Out Date.
We have Sheet 2 that we would like to pull this Send Out Date when the range between Task 1 - Task 4 display "Doc 2", and the client ID matches.
Is there anyway we can write a formula to capture the send out date from Sheet 1, when the following criteria matches:
1) Client ID
2) Task 1 - Task 4 display "Doc 2"
Appreciate assistance in working out this formula.
Help Article Resources
Check out the Formula Handbook template!