| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find multiple text in diff cells in another worksheet?
I am trying to take an Excel Spreadsheet that contains the names of all of my
customers and search a seperate spreadsheet that contains many customer names to see if any of the names on my list appear in that list. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find multiple text in diff cells in another worksheet?
One way...
Assume one list is on sheet1 starting in cell A1. The other list is on sheet2 starting in cell A1. We'll compare sheet1 list to sheet2 list. Enter this formula in sheet1 cell B1: =IF(COUNTIF(Sheet2!A:A,A1),"Yes","No") Copy down as needed. -- Biff Microsoft Excel MVP "Kristin" wrote in message ... I am trying to take an Excel Spreadsheet that contains the names of all of my customers and search a seperate spreadsheet that contains many customer names to see if any of the names on my list appear in that list. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find multiple text in diff cells in another worksheet
I believe this will give you what you want:
http://www.contextures.com/xlFunctions02.html Regards, Ryan-- -- RyGuy "T. Valko" wrote: One way... Assume one list is on sheet1 starting in cell A1. The other list is on sheet2 starting in cell A1. We'll compare sheet1 list to sheet2 list. Enter this formula in sheet1 cell B1: =IF(COUNTIF(Sheet2!A:A,A1),"Yes","No") Copy down as needed. -- Biff Microsoft Excel MVP "Kristin" wrote in message ... I am trying to take an Excel Spreadsheet that contains the names of all of my customers and search a seperate spreadsheet that contains many customer names to see if any of the names on my list appear in that list. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Worksheet Find | Excel Worksheet Functions | |||
| pull data for a company with data in diff cells multiple wrkshts | Excel Worksheet Functions | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY | Excel Worksheet Functions | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Linear Mode
