title: Excel Formula to fetch data from corresponding cells of a search result
body: <p>I have a tab in excel with employee details. Column B is first name, column C is last name,Column  H is their employment status ( LEFT, EMPLOYED ETC) </p>
  
  <p>I want a formula in next tab  to fetch the data of column H of a given name i want to search for.</p>
  
  <p>Lets say in the 2nd tab, i put name John Doe, Sam Bravo, Leah Casey and another 25 names. On the right handside cells of each name i entered, i need the employment status to appear. I have a database of 18000+ employees. So a formula for this will help a lot. Many thanks. </p>