# Compare a single cell to a column for matches

#### Jh31

##### New Member
Hey all,
I am working on comparing the contents of a cell against another column and cannot seem to get the formula to work. This is essentially what I am looking at. Column A will be a list of vendor companies from a specific LOB and column D is a list of vendors from the entire enterprise. I need a formula to return a match based on Cell A2 having a match somewhere in column D. Column A will have approx. 90,000 lines whereas column B will have about 450 lines. I have tried several formulas and none seem to work.

Here is what I think should be working. Either what am I doing incorrectly or what should I be doing differently?
Cell B2: =IF(A2=D:D,"TRUE","FALSE")

 Company Name (LOB) Match? Company Name (Enterprise) abc FALSE BAD bcd TRUE BAG cde FALSE BCD def FALSE CAT ghi TRUE CAM GHI

<TBODY>
</TBODY>

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Welcome to the board..

Try

=ISNUMBER(MATCH(A2,D:D,0))

Thank you so much. I believe that cures it!

Replies
9
Views
225
Replies
13
Views
685
Replies
12
Views
631
Replies
0
Views
495
Replies
12
Views
408

1,203,096
Messages
6,053,516
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back