title: Excel: Dropdown based Vlookup
body: <p>I have a dropdown where the user can select their desired brand.</p>
  
  <pre><code>HP
  Dell
  Razer
  Apple
  </code></pre>
  
  <p>In the second dropdown the user selects their desired build (for example i7) and then it returns the price.</p>
  
  <pre><code>i5
  i7
  i9
  
  =VLOOKUP(A1;'Apple'!A1:B3;2;FALSE)
  </code></pre>
  
  <p>How can I make the 'Apple' part of Vlookup above dynamic, based on the original dropdown choice? The sheets are identical excluding the price so the cells are the same.</p>