Not sure why the wild card is not working without seeing the workbook, but it might be more efficient to use the left function around the index & match?

Just an idea