DATA ENTRY - EXCEL / ACCESS / VBA

I have another job thats similar but it involves more searching. here are details/instructions: attached excel doc has three sheets, 1- keywords to search 2- data needed 3- sheet to search from column H and input appropiate data in adjacent cells. appropiate data comes from sheet 2 here are the steps: 1- search keyword list (in sheet 1) in column H (in sheet 3). VERY IMPORTANT - ONLY SEARCH EXACT PHRASE, DO NOT FIND TEXT INSIDE WORDS. SEPARATE MORE THAN 1 RESULT FOUND BY SLASHES "/". 2- SHEET 2 HAS THREE COLUMNS, 1 BATTERY MODEL #, 2 BRAND, 3 UNIT MODEL #. IF SEARCH FINDS A RESULT FROM COLUMN B AND COLUMN C, THEN ENTER BATTERY MODEL NUMBER FROM COLUMN A IN CELL OF COLUMN G (IN SHEET 3). ONLY IF SEARCH FINDS 2 RESULTS - AT LEAST 1 IN COLUMN B AND, NOT OR, AT LEAST 1 IN COLUMN C, SHOULD BATTERY MODEL # BE ENTERED. IF DATA IS FOUND IN ONLY 1 COLUMN - EITHER B OR C, THEN ENTER THIS DATA BUT DO NO ENTER BATTERY MODEL NUMBER. PLEASE SEE EXAMPLES I'VE INCLUDED IN SHEET.