match word in one column form list in another
 

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

match word in one column form list in another
 

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564427

match word in one column form list in another
 

There are numebs and text in the names

"daddylonglegs" wrote:


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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564427

match word in one column form list in another
 

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

"daddylonglegs" wrote:


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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564427

match word in one column form list in another
 

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.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564427