match word in one column form list in another

  • Thread starter Filter by first letter
  • Start date
F

Filter by first letter

two columns of company names - need to take company name in right column and
see if it matches upu in the lcolun ( list of company names) to the left
 
D

daddylonglegs

If your lists are in columns B and C then in A1 copied down

=IF(ISNUMBER(MATCH(B1,C:C,0)),"Match",""
 
F

Filter by first letter

So to clarify the list in column C has thousands of different company names
and I am trying to see if that name is in column B which has hundreds of names
 
D

daddylonglegs

That formula should work for you.

It needs to go in A1 then you can fill down as far as the names go in
column B

(should be able to do that automatically - put formula in A1 then put
cursor on bottom right of A1 until you see a black +. This is the "fill
handle". Still on bottom right corner with + visible double click to
fill formula down)

Don't be put off by the "ISNUMBER" part. It doesn't matter whether your
data is text or numeric - what this checks is if the result of the MATCH
function is a number or not, if it is you have a match, otherwise you
don't.
 
Top