title: Vlookup using 2 columns to reference another
body: <p>I am trying to do a vlookup under a circumstance of first then last name to get an age. This will be done within Column A, then Column B. If found in Column A, Continue to Column B, If found in Column B, put age in J3 that comes from Column C else put "None".</p>
  
  <p>Here is an example:</p>
  
  <pre><code>J1 = John
  J2 = Doe
  J3 = =VLOOKUP J1 &amp; J2,A1:C50,3,FALSE)
  </code></pre>
  
  <p>J3 is what I have so far. Do I need to nest a Vlookup to check Column A, then Column B in order to get the age?</p>
  
  <p>Here is an example of the table list:</p>
  
  <pre><code>A     B    C
  Jeff  Vel  80
  John  Fly  25
  Jake  Foo  20
  John  Doe  55
  </code></pre>
  
  <p>J3 = 55.</p>