I am trying to match first and last names between two worksheets with different sizes of the data. The array function {=MATCH(1,IF(SheetName!LastNameRange=LastName,IF(SheetName!FirstNameRange=FirstName,1)),0)} will give me the index of a match. I can also use this with the Evaluate function to get the result in a macro. My question is how best to handle the rows where there is no match, without having to execute the MATCH function twice. Is there any way to get the match index if successful and -1 upon error?
Bookmarks