Hello,

Not sure how to approach this formula...

I would like to have a formula that checks two criterias in the "State" and "Formula Check" columns and displays text from "Notes"

For example I want to display the note "1 Rear" in cell F4.
When the "State" is "MI"
When the "Formula Check" is "YES"

Excel Example.jpg

Thank you