title: IF FIND function doesn't find anything in vba then
body: <p>I'm currently automating a manual process that does the following steps:</p>
  
  <p>1.Prompts the user to open a data file and opens the file </p>
  
  <p>2.Inserts 4 columns</p>
  
  <p>3.Using the data that was already in the file creates a unique string in the format "DD/MM/YYYY TEXT" where text is a variable</p>
  
  <p>4.Uses an if statement to determine if a row exists within the Master Data File</p>
  
  <p>5.If the value in column d = "Exists" then find the string in the Master data file and use the vlookup function to transfer the data from the data file to the Master Data File</p>
  
  <p>6.Else (If the value = anything else) then Insert a new row name it and then use the vlookup function to transfer the data from the data file to the master file</p>
  
  <p>My issue lies with the fact that the Unq.String sometimes/rarely isn't an EXACT match so by using the FIND function it will return the message: "We can't find what you are looking for. Click options for more ways to search"</p>
  
  <p>My question to you guys is, is there a way that upon receiving this error message, that the data is then pasted on another tab called "mop up" before moving onto the next row? I'm using a LOOP within my code for steps 5 and 6 as I will need to jump down each row but I wouldn't know where to start this without breaking the loop.</p>
  
  <p>Thanks for your help in advance guys and let me know if you need any more information regarding the context.</p>
  
  <p>Aaron</p>
  
  <p>Thanks</p>
  
  <p>EDIT Comments explain how I plan to use this:</p>
  
  <pre><code>Dim ColumnD As String
  Dim SearchValue As String
  
  If ColumnD = "Exists" Then
  
  'Find SearchValue in Master data sheet and vlookup
  'ELSE Insert new row, add UNQ.String to New row then do the vlookup
  'Loop untill using Rows.count + 1 and lastRow (Already declared)
  </code></pre>