title: Vlookup a Cell which Contains a Part of Other Cell but not that Straightforward
body: <p>Hi guys and all Excel gurus, I am stuck with this one excel problem which I cannot solve. I tried using Index, Match, Vlookup but to no avail.</p>
  
  <p>Basically I tried getting Column D displays Value from Column B if the Value of Column C contains part of the value in Column A.</p>
  
  <p>So what I'm dealing with is something kind of like this:
  Fixed the table display</p>
  
  <pre><code>+------------------------------------------------------+
  | Header     Column A   Column B   Column C  Column D  |
  +------------------------------------------------------+
  | Row 1      111        AAA        1111                |
  | Row 2      222        BBB        112                 |
  | Row 3      333        CCC        2225                |
  | Row 4      444        DDD        333                 |
  +------------------------------------------------------+
  </code></pre>
  
  <p>So my expected result would be:</p>
  
  <pre><code>+------------------------------------------------------+
  | Header     Column A   Column B   Column C  Column D  |
  +------------------------------------------------------+
  | Row 1      111        AAA        1111      AAA       |
  | Row 2      222        BBB        112       N/A       |
  | Row 3      333        CCC        2225      BBB       |
  | Row 4      444        DDD        333       CCC       |
  +------------------------------------------------------+
  </code></pre>
  
  <p>Sorry for the poor table display and explanation. Thanks Guys.</p>