| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Partial Text Match then enter desired result into appropriate colu
I have a list of company names in Column A.
On a separate tab I have a list of keywords. What I'd like to do is to have a search done on the names in column A and if any of the keywords on the separate tab match for it to then put in the company type into column B. Example of a company name in column A: Get Things Done Construction Company Keyword on separate tab: "construction: Need the formula to return "construction" to Column B. Thanks in Advance for any insight on this one! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Partial Text Match then enter desired result into appropriate colu
Look in the help index for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "MMangen" wrote in message ... I have a list of company names in Column A. On a separate tab I have a list of keywords. What I'd like to do is to have a search done on the names in column A and if any of the keywords on the separate tab match for it to then put in the company type into column B. Example of a company name in column A: Get Things Done Construction Company Keyword on separate tab: "construction: Need the formula to return "construction" to Column B. Thanks in Advance for any insight on this one! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if with partial text match | Excel Worksheet Functions | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Vlookup using a partial text match | Excel Worksheet Functions | |||
| If specific text result,... corresponing cell info in another colu | Excel Worksheet Functions | |||
| partial/absolute text match | Excel Worksheet Functions | |||
Linear Mode
