Display Text With 2 Criterias

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

Try this

=LOOKUP(2,1/($A$2:$A$14=$F$2)/($B$2:$B$14=$F$3),$C$2:$C$14)

Excellent Works Perfect THANK YOU!

Originally Posted by Phuocam

Try this

=LOOKUP(2,1/($A$2:$A$14=$F$2)/($B$2:$B$14=$F$3),$C$2:$C$14)

This worked perfectly thank you Phuocam.
Here is another question, what if the formula is true for two rows. Can I include the notes from both cells into one cell?