ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   lookup problem (https://www.excelbanter.com/excel-programming/355882-lookup-problem.html)

Tim Whitley

lookup problem
 
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.


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com