title: Return value of a Cell as value if true or false of a function
body: <p>I would like to get a value of a particular cell as value if true or value if false option using functions in excel. the exact problem i have is as follow</p>
  
  <p>in column A I have the name list of the students and in column B I have their birthplace. Now I would like to find out the students from a particular city. </p>
  
  <p>The best solution i could find was to use:</p>
  
  <pre><code>=IF(COUNTIF(A1,"*California*"),"Yes","No")
  </code></pre>
  
  <p>But instead of "Yes", I want the students name from California of corresponding row.</p>