Compare values from 2 columns in 2 different data sheets

[ShwetaGupta]

Hello,

Here's what I need to do. I have values such as the following on 2 datasheets of the same excel :

Sheet 1 has a column with value = LE-1234-CA-9876
Sheet 2 has a column with value = 9876

I want to compare these 2 columns to give and output with what's present in sheet 1 but not in sheet 2 column.

Please suggest how this can be achieved.

Thanks,
Shweta

[young_86]

Soory i dn't understand what excactly do you want:/ do uou wanna check does eg.9876 apear on both sheets and then some text, value comment or something else. Please be more pecise.

[oeldere]

try this one


b1=vlookup(right(a1,4),Sheet2!$a1:$a1500,1,0)