Vlookup a part of a cell value in another sheet
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 vell value using like containg text and return the corresponding value of that cell |
All times are GMT +1. The time now is 12:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com