| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross reference two worksheets to identify matches
I have two spreadsheets, one with middle names and the other without. I need
a formula that will says its a match even though the middle name is not shown, for example: Sheet one - Surname: Smith (A1), Christian name: Michael John Sheet two - Surname: Smith (A1), Christian name: Michael After this narrows it down I would need to match the address on both spreadsheets. Can anyone help???? Christie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does anyone know how to cross reference two worksheets | Excel Worksheet Functions | |||
| Cross reference | Excel Worksheet Functions | |||
| How can I identify items that are matches using +/- 1? | Excel Worksheet Functions | |||
| How to identify same row matches in two columns of #s using Excel | Excel Discussion (Misc queries) | |||
| Cross Reference | Excel Worksheet Functions | |||
Threaded Mode
