title: Find text in column one and copy value from next column to column 3 in Excel
body: <p>Column 1 in my spread sheet contains text (just 1 word), 2nd column numbers and column 3 will have those numbers in specific order.<br>
  Example:  </p>
  
  <pre><code>cell   values
  A3     aaaa  
  A4     bbbb  
  A5     cccc  
  A6     dddd  
  A7     eeee  
  A8     ffff  
  
  B3     11  
  B4     22  
  B5     33  
  B6     44  
  B7     55  
  B8     66  
  </code></pre>
  
  <p>I want cell C3 to search the whole column A for a word <code>ffff</code> and once it found it, it would copy a value of the cell next to it in column B. So if the word <code>ffff</code> was in cell A8 the cell C3 would be <code>66</code> as B8=66. If <code>ffff</code> was in A5 than C3 would be <code>33</code> etc. After that I want C4 to find a word <code>cccc</code> in column A and copy value from next cell in column B and so on. Does anyone know how can I do it? Can this be done without using macros?</p>