D
david bonaccorsi
Key words:
Key word Category Code
ACCIDENT 1
ACCOUNT 2
ACCREDITATION 3
ADMISSION 4
AGREEMENT 5
ALARM 6
ANNUAL 7
APPLICATION 8
APPRAISAL 9
ARREST 10
--------------------------------
NMAC DocumentType Category
1.15.3.101 NON-RECORD MATERIALS
1.15.3.102 SUBJECT FILES
1.15.3.103 PRIMARY MISSION RECORDS
1.15.3.104 AGENCY ORGANIZATIONAL CHARTS
1.15.3.105 ADMINISTRATIVE RULES
1.15.3.106 ADMINISTRATIVE FILES (EXECUTIVE LEVELS)
1.15.3.107 ADMINISTRATIVE REFERENCE FILES (NON-EXECUTIVE LEVELS)
1.15.3.108 ADMINISTRATIVE CORRESPONDENCE FILES (EXECUTIVE LEVELS)
1.15.3.109 GENERAL CORRESPONDENCE FILES (NON-EXECUTIVE LEVELS)
1.15.3.110 INTERSTATE COMPACTS
------------------------------------------
I want to lookup the Key word in the first list, match it to Document Type in the second list, and populate the Category column in the second list with Category code from the first list.
These are only partial lists, so no worrys about finding matching keys words, since the key words were taken from the titles under Document Type.
Each list is on a separate sheet in the same workbook.
Either VBA or functions would work. Thanks.
EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx
Key word Category Code
ACCIDENT 1
ACCOUNT 2
ACCREDITATION 3
ADMISSION 4
AGREEMENT 5
ALARM 6
ANNUAL 7
APPLICATION 8
APPRAISAL 9
ARREST 10
--------------------------------
NMAC DocumentType Category
1.15.3.101 NON-RECORD MATERIALS
1.15.3.102 SUBJECT FILES
1.15.3.103 PRIMARY MISSION RECORDS
1.15.3.104 AGENCY ORGANIZATIONAL CHARTS
1.15.3.105 ADMINISTRATIVE RULES
1.15.3.106 ADMINISTRATIVE FILES (EXECUTIVE LEVELS)
1.15.3.107 ADMINISTRATIVE REFERENCE FILES (NON-EXECUTIVE LEVELS)
1.15.3.108 ADMINISTRATIVE CORRESPONDENCE FILES (EXECUTIVE LEVELS)
1.15.3.109 GENERAL CORRESPONDENCE FILES (NON-EXECUTIVE LEVELS)
1.15.3.110 INTERSTATE COMPACTS
------------------------------------------
I want to lookup the Key word in the first list, match it to Document Type in the second list, and populate the Category column in the second list with Category code from the first list.
These are only partial lists, so no worrys about finding matching keys words, since the key words were taken from the titles under Document Type.
Each list is on a separate sheet in the same workbook.
Either VBA or functions would work. Thanks.
EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx