title: Lookup & Reference formula not working in excel
body: <p>So I'm doing an excel project for fun. I am attempting to have columns M4 to O8 auto-fill with an N/A based on a selection from column E4 to E8, and to be left blank if the condition is false. With an If-then logic rule.</p>
  <p>All columns involved are using a drop down from a custom list created on a second sheet labelled DATA ENTRY.</p>
  <p>All tables are using text values.</p>
  <p>I am currently receiving the error:</p>
  <p>&quot;The value you entered is not valid. A user has restricted values that can be entered into this cell&quot;</p>
  <p>I attempted to utilize Vlookup for the table within my logic formula but have never done that before, nor am I sure that it is the right method if what I am attempting is even possible.</p>
  <p>Example of desired end result</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Rarity</th>
  <th style="text-align: center;">Trait</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">:Common:</td>
  <td style="text-align: center;">:N/A:</td>
  </tr>
  <tr>
  <td style="text-align: center;">:Rare:</td>
  <td style="text-align: center;">:{blank}:</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Sample of code I attempted:</p>
  <p>'''</p>
  <pre><code>    =IF($E$4:$E$8=&quot;COMMON&quot;, VLOOKUP('Data Entry'!$A$7, Traits,'Data Entry'!$B$36, FALSE))  
  </code></pre>
  <p>'''</p>
  <p>I'm positive this is not the correct method at this point. I really would just prefer for the second column (which is a dropdown menu) to autofill with a selection from my data list based on the value placed in column one (which is also a dropdown list)</p>