You could put it in any unused column--or even insert a new column just to hold
it.

But you will have to adjust the formula to match your data. I used A1 (all of
column A, in fact) as the cell/range to check to see if it appears in column C.

Brandy wrote:

Which column would I put this formula in?

"Dave Peterson" wrote:

You can use this kind of formula to determine if a value appears in another
column:

=isnumber(match(a1,c:c,0))

and drag down as far as you need.



Brandy wrote:

Ok. I hope I explain this correctly.

I have an excel worksheet. I have columns for "Vendor Names - Company A",
"Vendor # - Company A", "Vendor Names - Company B", "Vendor # - Company B".

I want to compare either the names or the numbers (doesn't matter which) and
find all the vendors that Company B has that Company A doesn't have.

Does that make sense? Is there an EASY way to do this?

Thank you.

--

Dave Peterson


--

Dave Peterson