title: Excel - Lookup data in another sheet
body: <p>I have the following dataset on Sheet 1:</p>
  
  <pre><code>ISBN        CType   CID     FullName
  1234567890  A01             John Smith
  1275910285  A07             Joe Bloggs
  7885419987  A01             Bob Thornton
  </code></pre>
  
  <p>I also have the following information on Sheet 2</p>
  
  <pre><code>CID         FullName
  7895123675  John Smith
  4210326985  Joe Bloggs
  75126548951 Bob Thornton
  </code></pre>
  
  <p>What I want is a formula or code that can do the following:</p>
  
  <p>The code will look at the <code>FullName</code> in Sheet 1 (55,000 Records) and in reference to sheet 2 (22,000 Records), it will search for the relevant <code>FullName</code> (22,000 unique records when it has the combination of <code>CID</code> and <code>FullName</code>) and populate the <code>CID</code> in Sheet 1 with the <code>CID</code> from Sheet 2.</p>
  
  <p>I have tried to use the <code>VLookUp</code> function however it hasn't worked at all!</p>
  
  <p>Any help is greatly appreciated!</p>