I'll give it a try but I'll tell you what might be the problem - the array is being populated from a combobox/listbox so it's populated with strings, not numbers.
That would be a problem if the column you were trying to find a match in had numeric data.
Hard to tell if that's the case because, well, there's no data on any of the sheets apart from a header row on 'Input'.
Another problem is that a match just isn't being found, perhaps because there's no data.
If that's what's happening here's how you can deal with it.
Bookmarks