Match Function in VBA finding strings

Hello! I am wondering why this code is throwing back an error??? I am trying to match to numbers that are like: 2014-01, 2015-15, 2017-24 etc...

The code gets the index with regular numbers, but it does not run with the 45-1 example I made. Please help!

Thanks!

Please Login or Register  to view this content.

If I change the given line to

Given = "45-1"

and run the code, with the string value in A3, then the result in D10 is 3.

So it appears that the code works for me.

So it appears that the code works for me.

Same here, even with "2014-01" etc. Of course Given has to be exact match of one of the values in column A since you use 0 in Match-function.