title: Excel VBA Worksheet Function Match Produces Error When Value Does Not Exist
body: <p>I attempted to use the MATCH function in Excel VBA coding. When I enter a part number and the MATCH function is able to locate the row in which it exists, no error occurs. However, when the value being searched for does not exist, I receive an error message that says it is "Unable to get the Match property of the WorksheetFunction class". It classifies this a run-time error '1004'. </p>
  
  <p>Since it produces this type of error, I am unable to use the iserror function or a set of if statements to try to parse it out; both values will always be FALSE.</p>
  
  <p>If there is a way to avoid this error please let me know!</p>