MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Searching For a Match

Posted by Eric on August 24, 2001 10:28 AM

I have two nearly-identical columns. I would
like to create a function that returns which elements
(or rows) are in one column but not in the other.

Any suggestions?

Posted by Eric ( different one :-) on August 24, 2001 11:06 AM

a vlookup "test"

say your two columns are a and b starting in row 2. To report the values in b that are not in column a, try putting the following formula into c2 and copy down
=if(iserror(vlookup(b2,a:a,1,false))=true,b2," ")

Posted by Eric on August 29, 2001 8:31 AM

Re: a vlookup "test"

Many thanks - never knew it existed. Can the arguments (i.e. arrival-date) be a cell reference? I have tried the function and checked help but I get a #value error.

Thanks in advance