title: can I make a vlookup find a certain word in a cell?
body: <p>What I am trying to do is.</p>
  
  <pre><code>=VLOOKUP(C7,MODEL!A$4:B$9975,2,FALSE)
  </code></pre>
  
  <p>For Cell C7--- Jacket Blue Men's</p>
  
  <p>What I want it to do is use a Symbol for Men's</p>
  
  <p>So my original sheet has the products all listed...this goes to another list and I want to make Jacket Blue Men's--------   | Jacket Blue |  ♂ |</p>
  
  <p>So Does Vlookup recognise (Men's) and will use the list to autofill another cell?</p>
  
  <p>I tried true and it gave me a <code>NA#</code></p>
  
  <p>Thanks...this is the last step in a MASSIVE puzzle</p>
  
  <p><strong>NEW QUESTION</strong></p>
  
  <p>Can I only have one Vlookup command per sheet?</p>
  
  <p>Also the current <code>=VLOOKUP(B397,Sheet2!C3:D5,2)</code>  IS returning a ♂  but the specific word in that cell is Women's  </p>
  
  <p>So I guess I need to figure out how it will differentuate between women's and Men's.  I have tried many formulas, and I get <code>NA#</code> or errors in the formulas.</p>
  
  <p>Can anyone answer this or am I really stuck and have to add ♂ and ♀ and Ω  to all 10k entries?</p>