Vlookup for two sheets in same workbook

R

Roberta

Ok. I am desparate. I've working on this for hours;

I have VIN numbers in sheet 1 in the range I2:I5521

I have VIN numbers in sheet 2 in the range G2:G4717.

I need to see if the VIN numbers in sheet 2 are on sheet 1, of so highlight
the cell or delete the VIN number. I'd really like to delete the duplicate.
 
T

Trevor Shuttleworth

Roberta

select column G in the second worksheet and name it "ColumnG" without the
quotes.

Then, select cells I2 down to I5521 in the first worksheet and choose Format
Conditional Formatting...

Change Condition 1 to: Formula: =VLOOKUP(I2,ColumnG,1,FALSE)=I2

choose a suitable background colour to highlight the cell.

You can then manually delete the cells/rows where the duplicate exists.

Alternatively, you could just use the lookup in another column and then
filter for TRUE on that column.

Regards

Trevor
 
R

Roberta

Hi Trevor. I intentionally placed a duplicate VIN no in sheet 2 and followed
your instructions and nothing showed up as duplicate.

In the conditional formatting where the Formula Is:
=vlookup(I2,ColumnG,1,False)=I2

Its stating look in I2 column and Column G, if data matches? Not sure I can
interpret the formula. Should False be true? Why just I2?
 
R

Roberta

Ok...I replied too soon. I got it. What I did was selected the entire
column G vs the cells in Col G that had data.

Thanks for saving me.
 
Top