Comparing Lists

[VegasL]

Hello,

In column A I have master list. In column B, I have a small list

Desired Result in in column C:

I am comparing column B against column A, only show when comparing where column a values are not in column b. else put ""

see attached file.

[mycon73]

Vegast,

Not following your logic or request

Looks like desired result is the same as Master List & if that's what you're seeking, just use "=A2" in cell C2

[Fluff13]

How about

Please Login or Register  to view this content.

[VegasL]

Thanks Fluff13...this works. is there an approach using if isna vlookup toward this as well?

[Fluff13]

Yup

Please Login or Register  to view this content.

[VegasL]

Thanks!.............................

[Fluff13]

You're welcome & thanks for the feedback