title: Excel VLOOKUP #REF Error
body: <p>I'm trying to create an integrated athletic planning and training calendar. Part of this is for one sheet to identify weeks in which races occur based upon races and dates identified by the user on another sheet. I've confirmed that my VLOOKUP is not referencing a non-existent column and that the cell style is General for those applicable. </p>
  
  <p>Here is the formula:</p>
  
  <pre><code>=VLOOKUP(Periods!A6,Races!$F$2:$F$20,2,FALSE)
  </code></pre>
  
  <p><img src="https://i.imgur.com/Cmu7U.png" alt="Image of the formula worksheet">
  <img src="https://i.imgur.com/nEhRf.png" alt="Image of the target worksheet"></p>
  
  <p>The Lookup Value is the Training week on the first image and is used to identify races on the target worksheet. Each row on that sheet has a different training week. I am trying to get Column D (and F) on the formula sheet to show the priority of the race if there is one planned for the applicable week.</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks!</p>
  
  <p>Mike</p>