title: Understanding the vlookup formula in Excel?
body: <p><img src="https://i.stack.imgur.com/CNZ67.jpg" alt="enter image description here"></p>
  
  <p>I have two lists in the spreadsheet and some of the names match and some do not. </p>
  
  <p>I need a formula so that where the text matches it can assign the corresponding value. </p>
  
  <p>For example: in B2 it would read a 0 or false because there is no Jimmy T. in the C column. However, in B3 the formula should work as if the text in A3 matches any text in the C column it assigns the corresponding D value that is directly to the right. So, in B3 the answer would be 47.33. </p>
  
  <p>The ultimate goals is for the value in the B column to correspond with Column A the same way that column C corresponds with column D.<br>
  And where there is not a value for column A to have it read "False" in column B.</p>