title: Search data from different sheet and show the results in sheet 1 (search using specific text)
body: <p>I'd like to ask for help on how to get the data from sheet 1 and get the data from Sheet 2 Column A  and view the results in Sheet 1 column B, looking or searching the first 3 char/digit. I have more than 15000 data in Sheet1 col A and my around 100 selection (type) in sheet 2. How to do this using macro..?</p>
  
  <pre><code>Example 
  Sheet1                                  on sheet 2
  Number (Col A) | Type (column B)           Col A   |  Col B (Type)
  A112XXX2           Engine1                 A112XXX2   Engine1
  B112AA12           ??                      B333QWE1   Engine2
  B222VXX2           ??                      C000XXX2   Engine3
  B333QWE1           ??                      Z312VVV9   Engine10
  .
  .
  </code></pre>
  
  <p>Basically using the first 4 Chars/digit (say A112 as my critera) in Sheet1 Col A is found on Sheet2 column A then  the data will appear in Sheet1 column-B  (type)</p>
  
  <p>Thank you and appreciate you help.
  wezzer</p>