title: Application.match in VBA
body: <p>I'm using "Application.match" to find if Column AD of a sheet contains "1".</p>
  
  <p>But whenever I try to run my code, "Else" condition is always True. Although I'm expecting it to enter the "If" condition, since Column AD has a cell with a value "1".</p>
  
  <p>The values of the cells in Column AD are mostly results of a formula, except for AD1, which has the string "Check if Titile&amp;Author Match", and AD2, which has the value "0".</p>
  
  <p>What is the problem. What is the solution for it?</p>
  
  <p>I hope you can suggest a solution that would still use the ".match" method. This is because from my understanding ".match" method returns the relative position of the match in the range. And I plan to use that value later on in my code.</p>
  
  <pre><code>Private Sub CmdLocateDta_Click()
  
  Dim SearchColumn As Integer
  
  If Not IsError(Application.Match(1, "AD:AD", 0)) Then
      SearchColumn = Application.Match(1, "AD", 0)
      MsgBox "Data has been located." &amp; vbNewLine &amp; _
             "You can now input the Lending Information below."
  Else
      MsgBox "There seems to be no such book in the Database." &amp; _
              vbNewLine &amp; "Please re-check your input."
  End If
  
  End Sub
  </code></pre>