title: VLOOKUP text inside a string
body: <p>I have a column <code>DeviceName</code> in <code>Sheet1</code> and it contains data like <code>RTRNY653, SWNY653, ...</code> In <code>Sheet2</code> I have a column <code>InterfaceName</code> and it contains interface names and at the end the device name is listed too <code>FA_01_RTRNY653, FA_12_SWNY653, ...</code></p>
  
  <p>The standard formula to get the <code>QoSID</code> linked to the <code>DeviceName</code> would be <code>=VLOOKUP(DeviceName;Sheet2!InterfaceName;2;0)</code>, but because <code>InterfaceName</code> contains more text, I'm stuck ...</p>
  
  <p>Question: How can I create a VLOOKUP function that uses the <code>DeviceName</code> from <code>Sheet1</code>, looks it up in the <code>InterfaceName</code> on <code>Sheet2</code> and gets me column <code>QoSID</code> from <code>Sheet2</code>.</p>
  
  <p><strong>Example data</strong></p>
  
  <pre><code>Sheet1
  DeviceName
  -----------
  RTRNY653
  SWNY653
  RTRWS215
  RTRCH888
  
  Sheet2
  InterfaceName     | QoSID
  --------------------------
  FA_01_RTRNY653    |   1
  FA_12_SWNY653     |   2
  S_00_RTRWS215     |   1
  S_01_RTRWS215     |   3
  </code></pre>