If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|