| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching address with two seperate worksheets
I have two worksheets with names and address. How do I match these?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching address with two seperate worksheets
Christie
What do you mean by "match"? Do you want to compare the contents of one sheet with that of the other sheet to find a match if there is one? What do you want to happen or do when you find a match? HTH Otto "Christie" wrote in message ... I have two worksheets with names and address. How do I match these? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching address with two seperate worksheets
I want to compare the contents of one sheet to another. I need it to say YES
if the name and address matches the name and address of the other spreasheet sheet. If it doesn't match to say no. "Otto Moehrbach" wrote: Christie What do you mean by "match"? Do you want to compare the contents of one sheet with that of the other sheet to find a match if there is one? What do you want to happen or do when you find a match? HTH Otto "Christie" wrote in message ... I have two worksheets with names and address. How do I match these? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching address with two seperate worksheets
=IF(Sheet1!A1=Sheet2!A1,"Yes","No")
Use the AND function if you want to compare more than one pair of cells at a time. -- David Biddulph "Christie" wrote in message ... I want to compare the contents of one sheet to another. I need it to say YES if the name and address matches the name and address of the other spreasheet sheet. If it doesn't match to say no. "Otto Moehrbach" wrote: Christie What do you mean by "match"? Do you want to compare the contents of one sheet with that of the other sheet to find a match if there is one? What do you want to happen or do when you find a match? HTH Otto "Christie" wrote in message ... I have two worksheets with names and address. How do I match these? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching address with two seperate worksheets
Christie
Do you want to compare row 1 of one sheet to ONLY row 1 of the other sheet or do you want to compare row 1 of one sheet to EVERY row of the other sheet? If you want to compare to every row in the other sheet, where do you want the Yes/No? Otto "Christie" wrote in message ... I want to compare the contents of one sheet to another. I need it to say YES if the name and address matches the name and address of the other spreasheet sheet. If it doesn't match to say no. "Otto Moehrbach" wrote: Christie What do you mean by "match"? Do you want to compare the contents of one sheet with that of the other sheet to find a match if there is one? What do you want to happen or do when you find a match? HTH Otto "Christie" wrote in message ... I have two worksheets with names and address. How do I match these? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching address with two seperate worksheets
I want to compare 1 row with the entire sheet but I also wnat there name to
match aswell. So the name and address need to match. "Otto Moehrbach" wrote: Christie Do you want to compare row 1 of one sheet to ONLY row 1 of the other sheet or do you want to compare row 1 of one sheet to EVERY row of the other sheet? If you want to compare to every row in the other sheet, where do you want the Yes/No? Otto "Christie" wrote in message ... I want to compare the contents of one sheet to another. I need it to say YES if the name and address matches the name and address of the other spreasheet sheet. If it doesn't match to say no. "Otto Moehrbach" wrote: Christie What do you mean by "match"? Do you want to compare the contents of one sheet with that of the other sheet to find a match if there is one? What do you want to happen or do when you find a match? HTH Otto "Christie" wrote in message ... I have two worksheets with names and address. How do I match these? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching data/columns from two seperate files | Excel Discussion (Misc queries) | |||
| Cell Address Matching | Excel Worksheet Functions | |||
| Matching data from seperate excel files | Excel Worksheet Functions | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
| Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
