title: Excel Macro to search for files based on a keyword and return true if present
body: <p>Can someone help me out with a excel VBA macro to search for files in various directories provide in column B, based on keywords given in column A and return "File Present"/"File Not Present" in column C. </p>
  
  <p>Example</p>
  
  <p>Keyword | FolderPath | Result</p>
  
  <p>1234 | E:\Documents\ABC</p>
  
  <p>Apple | F:\</p>
  
  <p>File2 | E:\Documents\Test\  </p>
  
  <p>I'm new to excel Macros. Please help me out!</p>
  
  <p>Thanks in advance!</p>