title: IF(AND) formula where multiple criteria need to be a match is not working
body: <p>I am trying to get a TRUE/FALSE value when 4 criteria match.
  On the Sheet3 tab, I would like to have either TRUE or FALSE under col C if the following are a match:
  Sheet3!F2 = ActionPlan!B2:B6; Sheet3!F1 = ActionPlan!A2:A6; Sheet3!B2 = ActionPlan!D1:H1; and if there is a &quot;No&quot; in the data range ActionPlan!D2:H6
  Please see the example sheet here: <a href="https://docs.google.com/spreadsheets/d/1VBrkVwBa5jXcrQXwB7QGFJhgcbBfjcmCawV7B1YqPcI/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1VBrkVwBa5jXcrQXwB7QGFJhgcbBfjcmCawV7B1YqPcI/edit?usp=sharing</a>
  Would anyone be able to help please? Thanks in advance!</p>