LOOKUP Formula based on result between date range

Richard Heath
Richard Heath ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

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.

Thanks

Richard. 

Capture.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!