| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto updating list | Excel Worksheet Functions | |||
| Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
| Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Hybrid Mode
