i am using Vlookup and getting data from another sheet, my main data source
is a file downloaded from net, in that file the feild having company name
usually change due to any suffix or prefix and then i cant get the data of
that company from v lookup bcz company name got changed, what i have to do
now is to build a formula which can lookup a value in another sheet contaning
any word or a part of the company name, like ( if i have to find the
corresponding value of a commpany name "Microsoft Corporation" and the
downloaded file for daily update have the name today as "Microsoft
Corporation Ltd." now the Vlookup formula cant get the value of that specific
row) if anything can help to find the cell value using like containg text and
return the corresponding value of that cell with vlookup or by any mean.
I am using Microsoft Excel 2003