Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
Merge Excel data into specific form areas in a Word Doc duugg Excel Discussion (Misc queries) 1 April 21st 06 08:25 PM
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! duugg Excel Discussion (Misc queries) 1 April 21st 06 02:35 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 03:49 AM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"