Compare Two Columns and Return difference

[Sayth]

Hi

I have two columns of values and I want to compare them and return differing values. So I named the ranges "A" and "B" so if your in B but not in A I want that value in C.

I started with a vlookup but that doesn't seem appropriate to the way I was using it.
=VLOOKUP(B, A, A, FALSE)

Is there a function better for this.

 

[Sayth]

Found an answer for office 2000. from here Excel Comparing 2 columns in Excel

1. Select column B (click the letter B)
2. Choose Format > Conditional formatting
" 3. In ""Condition 1"" choose ""Formula is"""
" 4. Enter this formula =(COUNTIF($A:$A,B1)=0)*(B1<>"")"
" 5. Click the ""Formats"" button and take your pick. OK.OK."