title: excel vlookup to match on 2 criterias and return a 3rd result
body: <p>Sheet is on the cloud, and being used by people with Google Sheets, so VBA is out unfortunately.</p>
  <p>Trying to get a vlookup to check 'Monday!A3' with 'Weekly Roster!E:E', but it also has to match 'Monday!E1' with 'Weekly Roster!G:G' and then returned 'Weekly Roster!H'</p>
  <p>If this was VBA I'd be able to smash it out, but unfortunately its not!</p>
  <p>Have tried numerous different ways, and they don't work! Here are some below examples;</p>
  <pre><code>=AND(VLOOKUP(E1,'Weekly Roster'!A:M,8,FALSE),VLOOKUP(A3,'Weekly Roster'!A:M,8,FALSE))
  =VLOOKUP(A3, IF(E1='Weekly Roster'!G:G,'Weekly Roster'!H:H,&quot;&quot;), 8, FALSE)
  </code></pre>
  <p>(And some others that have been deleted!)</p>
  <p>If someone could point me in the right direction that'd be fantastic! Appreciate the help!</p>
  <p>Sheet = Monday -&gt; Matching 'Monday!A3' to 'Weekly Roster!E:E' and then also matching 'Monday!E1' to 'Weekly Roster!G:G' and returning 'Weekly Roster!H'</p>
  <p>Monday Sheet:
  <a href="https://i.stack.imgur.com/grXTZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/grXTZ.png" alt="Monday Sheet" /></a></p>
  <p>Weekly Roster:
  <a href="https://i.stack.imgur.com/7Dj76.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7Dj76.png" alt="Weekly Roster" /></a></p>