LOOKUP Formula based on result between date range
I've tried to create a LOOKUP formula that will provide the "Approved Value" if the "Date Certified" calls between the period stipulated in "Period Start" and "Period End," without much success.
Based on the screen-grab, only two values should be returned if the formula is successful. (I've manually entered these to show the values.).
Assistance would be appreciated.
Help Article Resources
Check out the Formula Handbook template!