title: Need to find a value that matches two columns of criteria. Possible VLOOKUP
body: <p><strong>Update Below -- 6/4</strong></p>
  
  <p>I have two worksheets in excel. One is a list of donors with their check#/amount/ Donor ID ( "<em>donations</em>" worksheet) and the other is a copy of the accounting info with Donor ID/check#/amounts (<em>quickbooks</em> worksheet). Quickbooks does not have the DonorID's filled in yet. </p>
  
  <p>The issue I have is that i need match up Donor ID's with their checks. To get this i need to match the <code>check#</code> and <code>amount</code> in "Quickbooks" to the same in "Donations",  when they match,  it will give me the Donor ID that corresponds with that check.</p>
  
  <p>Here is how it is laid out:</p>
  
  <pre><code>Donations Worksheet:
       A                  B           C
   DonationID           Check#     Amount
  1   179                106        $200
  2   210                106        $500
  3   220                106        $600
  
  Quickbooks Worksheet:
        A                B          C
    DonationID         Check#     Amount
  1    n/a              106        200
  2    N/a              1074       500
  3    N/a              300        1000
  </code></pre>
  
  <p>When I ask to find "check# 106 is for $200"  it should tell me that it is from Donor 179. </p>
  
  <p>Some checks don't match and are not from donors. The list has close to 50000 names.</p>
  
  <p>Please ask me any questions so i can clarify this more. I am also somewhat new to all this and apologize if I am not to clear.</p>
  
  <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p>
  
  <p>Thanks everyone for your help. We are not there yet but you were all steering me in the right direction.</p>
  
  <p>I have added a screen shot of the page for reference because the team was having issues making the given formula's work. I also combined the two sheets onto one page so there is less cross worksheet referencing and will be easier to read.</p>
  
  <p><strong>Cknum = Check#</strong> </p>
  
  <p><img src="https://i.stack.imgur.com/ktSLB.jpg" alt="worksheet"></p>