Error Handling when value not found using match

Hi, I have a function that uses match to see if a value is in an array. If it is in the array it returns the position so that I can access corresponding data in other arrays. It works when there is a match but I am having trouble when the value doesnt exist. Below is my function.

Please Login or Register  to view this content.

jindon, that worked. Thank you!

Just curious. Before I was getting a type mismatch...Is this due to me first declaring pos as a double, and then the match function trying to pass a non double value to pos?

That's correct.

Unlike WorksheetFunction Match method, Application Match method returns Error value when it does not find match, so the variable should be able to receive error value hence Variant type.

That makes a lot of sense now.

Thank you for your help and the explanation!

You are welcome.