In the attached example I want to return the send date (Column A) by searching for part of the value in Column B.
So I want to search the contents of Column B for the value provided in B8, and return the value in A5.
I'm trying to use INDEX and MATCH to do that, but it's throwing an error when I try to ask it to match on a wildcard value.
Bookmarks