| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching key fields between two workbooks and displaying info when
Hi
I have two workbooks with the following info that should be the same - but I know it isnt Work book 1 Column A ColumnB Op number EA100, Part number BAC100123 Op number EA100, Part number BAC100124 Op number EA100, Part number BAC100125 Workbook 2 Op number EA100, Part number BAC100123 As above As above I want to create a formula that compares the op number and then flags when the part number is not the same. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy info while matching labels? | Excel Worksheet Functions | |||
| Finding matching fields accross multiple worksheets | Excel Discussion (Misc queries) | |||
| matching multiples fields in 1 row | Excel Worksheet Functions | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Displaying info in a new tab in excel | Excel Worksheet Functions | |||
Threaded Mode
