title: Excel spreadsheet check two conditions along different rows & columns
body: <p>Hey I'm really stuck on this one, basically tying to get a result of either 'hired' or 'available' (or 0 &amp; 1 to represent) in B2, of BOTH the two conditions in B1 &amp; A2, looking at the log table A6:B10 of when they are 'hired out'. I've tried VLOOKUP and many IF functions but neither quite work correctly.</p>
  
  <p><a href="https://i.stack.imgur.com/IT55k.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IT55k.jpg" alt="Spreadsheet example"></a></p>