title: VLOOKUP and insert a specific value
body: <p>i have two sheets in excel 2007 and i want to search if the value in sheet1 A1 exists in sheet2 array B then insert in sheet1 C1 the value of the specific cell A that the value was found.</p>
  
  <p>ex. if the value of sheet1!A1 was found in the sheet2!B7 then insert the value sheet2!A7 in cell sheet1!C1.</p>
  
  <p>=IF(ISNA(VLOOKUP(Sheet1!A1;Sheet2!B1:B999;1;FALSE));"Not Found";&lt;>) </p>
  
  <p>thank you </p>