Will do my best to explain what I'm trying to do here, new to this and far from an excel pro!
I have a list of projects and the companies those projects were with on a file. Im trying to pull in the date of the most recent project with the account but I want to only look for dates BEFORE a date captured on the list of projects.
So my sheet looks like..
I want to pull in the most recent 'project date' from another tab where the account ID matches, don't want to get any future dates and need to avoid pulling in the date from the project ID in column A.
I have a list of projects and the companies those projects were with on a file. Im trying to pull in the date of the most recent project with the account but I want to only look for dates BEFORE a date captured on the list of projects.
So my sheet looks like..
| Project ID | Account ID | Project Date |
| 12345 | 6789 | 4/3/24 |
I want to pull in the most recent 'project date' from another tab where the account ID matches, don't want to get any future dates and need to avoid pulling in the date from the project ID in column A.
