How to match values of one sheet on another sheet

Question

I have two sheets sheet1, sheet2. Sheet2 having the with records and duplicate number. like sheet1 1----a------ 100 1----a-------200 2----b-------200 2----b-------200 2----b-------200 3----c-------200 3----c-------200 sheet2 having the data like 1---a-----300 2---b-----600 4---d-----200 How to match these two sheets and highlight the values in sheet1 where the values are unmatched. thanks in advance JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

The best way to handle this is to use Conditional Formating. You have to use a Named Range to handle multi-sheet CF, so on Sheet2, select the first column of the range you want to check (A1 to A3 in your example) and on the top left of the screen, just below the ribbon, type a name, something like MySource or whatever. Select the whole range where you want to apply the formatting (Sheet1, cells A1 to C7 in your example) then, go to the ribbon (first tab): Conditional Formating > New rule.... Select Use a formula. Add this kind of formula to the field: =ISNA(VLOOKUP($A1, MySource, 1,0)) Note: you can remove the ISNA to select the cells that match.