title: If match error when a value does not match
body: <p>I currently have this:
  <code>=IF(MATCH("Example",D:D,0),"Not Available","Available")</code>. The problem is that if the value isn't in the column, it gives the #N/A error. How do I make that go away? I have read several similar problems that might have had the solution but couldn't make sense of it.</p>