Hello all, I was trying to figure this one out using an if(isna(vlookup type of formula but not getting the desired results. I need to identify specific rows of data that meet a certain criteria, I know it sounds simple. Here is an explanation of the attached file.\n \nWhen a patient (Ryan Seacrest) visits us we log every procedure we perform whether it is billable or not. So every line of data represents a specific medical procedure performed for Mr. Seacrest. But look again, you will see Duplicates of data (this is all on the same day). So the data came out of our software screwy (which is why we bought new software). If you scroll to the far right and look at column H you will see it is already sorted by CPT code, and its showing a multiple claim\/payment amounts for the exact same code is columns E and F.\n \n(you will also see my very rudimentary formula for checking for duplicates in column I)\n \nI need a formula or macro that will find a match for columns H and E in Sheet1 to Sheet2. Why? I need to preserve the values of column F because in some cases we were paid, in other cases we were not paid, and I need to filter for the code with the right claim amount to do that. Thank You in advance!\n \n***NOTE: I had to delete columns I and F (which had formulas) to get the file small enough to upload, but those were of no consequence.