Return value from another sheet based on 2 criteria
I'm seeking to write a formula that returns the value in the cell for column "hours reported", when the criteria is met in two other columns.
Here are the specifics:
Sheet B is dynamic where the 3 columns referenced are 1) name of the project, 2) is a date and 3) are hours reported
In Sheet A, I want to return the hours reported if the project name is the Project name@row and the date is within the last 7 days.
How would I write this?
Help Article Resources
Check out the Formula Handbook template!