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")
<TBODY>
</TBODY>
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>
