| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FINDING SIMILAR RECORDS BETWEEN 2 SPREADSHEETS
I have one spreadsheet that shows the original invoice # of 003567457A and
new version spreadsheet that shows the new invoice is now 003567457AR. I'm trying to find a formula like vlookup that will match the newer version invoice with the older version invoice because it is "similar" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Non-identical but Similar Records | Excel Discussion (Misc queries) | |||
| similar names - two spreadsheets | Excel Worksheet Functions | |||
| How to identify when similar records appear in two sets of data | Excel Discussion (Misc queries) | |||
| Merging slightly similar records | Excel Discussion (Misc queries) | |||
| getting unique records similar to the primary key in access | Excel Worksheet Functions | |||
Threaded Mode
