| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
matching key fields between two workbooks and displaying info when
Use the vlookup function.
In Col C put a 'cheater formula' something like... =IF(VLOOKUP(A1,[Book3]Sheet2!$A:$B,2,FALSE)<B1,"Not the same!","") -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "tukky142" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
