title: Excel: Partial matching Range 1 against each cell string individually in Range 2, then returning value in column
body: <p><em>If you can help me I love you.</em></p>
  <p>Let's say I have a bunch of URLs:</p>
  <pre><code>| Range 1                |
  |------------------------|
  | www.orange.com         |
  | www.orange.example.com |
  | www.example.red.com    |
  | www.example.com/blue   |
  </code></pre>
  <p>And I also have a table like this:</p>
  <pre><code>| Range 2 | Range 3 |
  |---------|---------|
  | orange  |       1 |
  | red     |       2 |
  | blue    |       3 |
  | green   |       4 |
  | pink    |       5 |
  </code></pre>
  <p>How could I write a formula to pull down alongside the URL list so that it looks like:</p>
  <pre><code>| Range 1                | Results |
  |------------------------|---------|
  | www.orange.com         |       1 |
  | www.orange.example.com |       1 |
  | www.example.red.com    |       2 |
  | www.example.com/blue   |       3 |
  </code></pre>
  <p>Essentially doing partial matches every time and then returning a result to the right.</p>
  <p>Driving me nuts, you're my only hope!</p>