SOLVED

Search for matching cell value on another worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2815248%22%20slang%3D%22en-US%22%3ESearch%20for%20matching%20cell%20value%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2815248%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20Community%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20trying%20to%20do%20is%20confirm%20that%20the%20values%20in%20column%20B%20in%20one%20worksheet%20are%20contained%20in%20column%20B%20of%20another%20worksheet.%26nbsp%3B%20The%20list%20I'm%20wanting%20to%20evaluate%20is%20over%201%2C000%20cells%20in%20length.%26nbsp%3B%20The%20example%20that%20I%20attached%20contains%20about%2020%20-%20but%20you%20get%20the%20idea.%26nbsp%3B%20I'm%20not%20very%20fluent%20in%20Excel%2C%20so%20I%20thought%20I%20could%20get%20some%20guidance%20from%20those%20in%20the%20know.%26nbsp%3B%20A%20quick%20alphabet%20search%20mentions%20VBA%2C%20but%20I%20don't%20know%20what%20that%20means%20or%20if%20there's%20even%20another%20option.%26nbsp%3B%20Any%20help%20is%20greatly%20appreciated!%26nbsp%3B%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2815248%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2815328%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20for%20matching%20cell%20value%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2815328%22%20slang%3D%22en-US%22%3E%3DVLOOKUP(B5%2C'Combined%20Tracking%20Punch%20List'!%24B%245%3A%24B%2485%2C1%2CFALSE)%3CBR%20%2F%3EEnter%20formula%20in%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22%20in%20cell%20F5.%3CBR%20%2F%3EThen%20copy%20formula%20down%20to%20F64.%20Formula%20returns%20description%20names%20in%20all%20cells.%20This%20means%20that%20all%20descriptions%20from%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22%20are%20found%20in%20sheet%20%22Combined%20Tracking%20Punch%20List%22%20in%20range%20%24B%245%3A%24B%2485.%3CBR%20%2F%3E%3DVLOOKUP(B5%2C'LREG%20-%20Tracking%20Punch%20List'!%24B%243%3A%24B%2464%2C1%2CFALSE)%3CBR%20%2F%3EEnter%20formula%20in%20sheet%20%22Combined%20Tracking%20Punch%20List%22%20in%20cell%20F5%20and%20copy%20formula%20down%20to%20the%20end%20of%20the%20list.%3CBR%20%2F%3EFormula%20returns%20%22%20%23NA%20%22%20in%20some%20cells%2C%20which%20means%20that%20description%20from%20sheet%20is%20not%20found%20in%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2815336%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20for%20matching%20cell%20value%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2815336%22%20slang%3D%22en-US%22%3E%3DVLOOKUP(B5%2C'Combined%20Tracking%20Punch%20List'!%24B%245%3A%24B%2485%2C1%2CFALSE)%3CBR%20%2F%3EEnter%20formula%20in%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22%20in%20cell%20F5.%3CBR%20%2F%3EThen%20copy%20formula%20down%20to%20F64.%20Formula%20returns%20description%20names%20in%20all%20cells.%20This%20means%20that%20all%20descriptions%20from%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22%20are%20found%20in%20sheet%20%22Combined%20Tracking%20Punch%20List%22%20in%20range%20%24B%245%3A%24B%2485.%3CBR%20%2F%3E%3DVLOOKUP(B5%2C'LREG%20-%20Tracking%20Punch%20List'!%24B%245%3A%24B%2466%2C1%2CFALSE)%3CBR%20%2F%3EEnter%20formula%20in%20sheet%20%22Combined%20Tracking%20Punch%20List%22%20in%20cell%20F5%20and%20copy%20formula%20down%20to%20the%20end%20of%20the%20list.%3CBR%20%2F%3EFormula%20returns%20%22%20%23NA%20%22%20in%20some%20cells%2C%20which%20means%20that%20description%20from%20sheet%20is%20not%20found%20in%20sheet%20%22LREG%20-%20Tracking%20Punch%20List%22.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, Community -

 

What I am trying to do is confirm that the values in column B in one worksheet are contained in column B of another worksheet.  The list I'm wanting to evaluate is over 1,000 cells in length.  The example that I attached contains about 20 - but you get the idea.  I'm not very fluent in Excel, so I thought I could get some guidance from those in the know.  A quick alphabet search mentions VBA, but I don't know what that means or if there's even another option.  Any help is greatly appreciated!  Thanks in advance.

1 Reply
best response confirmed by Roddy8892 (Occasional Visitor)
Solution
=VLOOKUP(B5,'Combined Tracking Punch List'!$B$5:$B$85,1,FALSE)
Enter formula in sheet "LREG - Tracking Punch List" in cell F5.
Then copy formula down to F64. Formula returns description names in all cells. This means that all descriptions from sheet "LREG - Tracking Punch List" are found in sheet "Combined Tracking Punch List" in range $B$5:$B$85.
=VLOOKUP(B5,'LREG - Tracking Punch List'!$B$5:$B$66,1,FALSE)
Enter formula in sheet "Combined Tracking Punch List" in cell F5 and copy formula down to the end of the list.
Formula returns " #NA " in some cells, which means that description from sheet is not found in sheet "LREG - Tracking Punch List".