title: VLOOKUP to the left
body: <p>I've read <a href="https://www.benlcollins.com/spreadsheets/vlookup-left/" rel="nofollow noreferrer">this article</a> and tried it out myself with the formula</p>
  <pre><code>=VLOOKUP(C1;{Daten!B2:B10;Daten!A2:A10};2;false)
  </code></pre>
  <p>Note that I'm using the German version, so using &quot;;&quot; as delimiter is fine. This formula doesn't give me a syntax error but I get &quot;#REF!&quot; as error. Can somebody explain what I did wrong? By the way: If I write</p>
  <pre><code>=VLOOKUP(C1;{Daten!B2:B10;Daten!A2:A10};1;false)
  </code></pre>
  <p>instead it perfectly works fine and I just get the value of C1 back what is kind of pointless.</p>