Forum Discussion

Roddy8892's avatar
Roddy8892
Copper Contributor
Oct 05, 2021
Solved

Search for matching cell value on another worksheet

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 c...
Formulas and Functions
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Oct 05, 2021
    =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".
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 05, 2021
=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".

Resources