I am trying to lookup a value while ignoring the first 5 characters. In my sample book I have 7 names that have numbers in front of them. The lookup range just has the names without the numbers but with a value in the next column. I am trying to match the names and return the value only. Any help would be greatly appreciated. Again, in my sample I am looking for ART FINCH.
Bookmarks