I have run into a problem with the MATCH function. My problem is that I would like to match the first part of a title but not the whole title. My primary example of this is when I am reading financial statements from Marketwatch or Finance.Yahoo. When I want to find the row number so I can use the MATCH and INDEX, I want to find a part of the title that is downloaded. To resolve this I have made a UDF named PARTIAL MATCH. This PARTIAL MATCH is illustrated below.
Description of the Problem
Code for Resolving the Issue
I thought I could do this without a range name.