DATA ENTRY - EXCEL / ACCESS / VBA

dI 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.
Read More to Apply

Budget: $30-$250 USD
Project Posted by: esnado

0 comments:

Post a Comment