I've been trying to analyze and return information similar to a vlookup
function. The difference is that I would like to take it a step further and
use programming that would give me results that most closely match my
criteria. For instance, if the criteria is a company name, "Dow Jones, Inc",
I want the returned value to be the column related to "DowJones" and not Dow
James (which would possibly be the result in a vlookup). I understand there
is a "LIKE" qualifier that could do this but I am too much of a newbie to put
it into programming language. Thanks in advance for any help that could be
provided.