title: Excel VLookUP on drop down list
body: <p>I have two sheets in excel, Submission and Validation.  On my Validation Sheet I have my two sources of information. Column G holds my community names, the thing in my list. Column H holds my NumberCode, the thing I want to auto populate. </p>
  
  <p>Example Validation:</p>
  
  <pre><code>G       H
  Venice  26423
  Scarborough 24741
  </code></pre>
  
  <p>On my Submission sheet I have a data validation drop down list. whose information is:</p>
  
  <p><a href="https://i.stack.imgur.com/Twagd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Twagd.png" alt="enter image description here"></a></p>
  
  <p>I am trying to lookup the codes so that when my dropdown list has Venice, the cell next to it should auto-populate 26423. My latest iteration of the Vlookup code is:</p>
  
  <pre><code>=VLOOKUP('Validation Page'!G1:G1067,'Validation Page'!H1:H1067,,FALSE)
  </code></pre>
  
  <p>I have tried putting it into tables, putting it into name reference, ect but nothing seems to want to populate. I either get #N/A or another error. Any help?</p>