Looking for a way to make Vlookup using 'TRUE' more precise
I am looking for a way to change the precision of a vlookup using 'TRUE' I have a large data set that has many repeated values that are slightly different in formatting and I need to attach the same identifier to each iteration of these text values. eg:
Discovery Company, Ltd
Discovery Co. Limited
Discovery Company Limited
Discovery Co., Ltd.
Any ideas . . ?
And you don't want to do a find and replace to use a "standard" name version or add a column with a standardized name then work off that using the 'FALSE' part of lookup?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Something like =VLOOKUP("Discovery Co*",range, col_nr,false) ?
Col a Col b
Discovery Company, Ltd = Discovery Company, Ltd
Discovery Co. Limited = Discovery Company, Ltd
Discovery Company Limited = Discovery Company, Ltd
Discovery Co., Ltd. = Discovery Company, Ltd
and then use vlookup from col b
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
More on this . . . What if I have . . .
Discovery Company, Ltd
Discovery Co. Limited
Discovery Company Limited
Discovery Co., Ltd.
Discover Company.
DISCOVERY CO.
Discovering Ltd.
Discovery National, Co.
italicized would all have different identifiers . . .
Are they all different names or different spell for the same name
Some different spellings of the same name, some different names altogether. . . :/Originally Posted by rajeshturaha
Put a common name for all those are different spelling for a same name in the corresponding col.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks