title: How to find table cell value based on condition provided in column and row?
body: <p>Title might not be that descriptive, but didn't find a better one. Basically please look at the screenshot:  </p>
  
  <p><img src="https://i.stack.imgur.com/ZsRMo.png" alt="Excel screenshot"></p>
  
  <p>Table A1:I7 - is a table of <code>Factors</code>. This is dictionary data which allows me to select the factor based on <code>A</code> and <code>B</code> values. </p>
  
  <p>Table A11:C15 - is a table where I have to put a lot of input data (pairs of <code>A</code> and <code>B</code>) and want its <code>Factor</code> column to be populated using the <code>Factors</code> table.</p>
  
  <p>Is there a way to make Excel automatically calculate (or should I say - lookup) the value for the factor according to values of <code>A</code> and <code>B</code> in that row, without macro usage, just using formulas?</p>