title: Excel | Searching table in different sheet and bringing value from column in that row
body: <p>I am trying to lookup a table in one of my sheets. my table consists of three columns and an unlimited amount of rows. </p>
  
  <p>My table can be seen here:</p>
  
  <p><a href="https://i.stack.imgur.com/s87bQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s87bQ.png" alt="enter image description here"></a></p>
  
  <p>In my second sheet I wish to write a formula which searches all rows in the table and looks for an exact match in column A and column B, this means it must find the row where column a has a value of "jan" and in that same row the second column must have value "y". Should it find this match, it should return the value of column C.</p>
  
  <p>I tried researching hlookup but that is for horizontal tables so i dont believe this would work. I looked into Vlookups also but that only allows one criteria search instead of looking for two matches.</p>
  
  <p>Can anyone shed some light here please? </p>