Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare 2 sheets
I work for a pharmacy and I have 2 spreadsheets in a workbook. One is a list
of all of the drugs we have in stock, sheet1. The other, sheet 2, is a list of drugs that we have to do a certain thing with. I need to compare the 2 and pull out every drug that is on sheet 1 AND sheet 2. What would be the easiest way to accomplish this? I use Excel 2000. I know how to use macros, and I know a little VB, but not enough to write something up from scratch. Thanks, Brian Mosher |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare 2 sheets
Personally, I would use a VLOOKUP, looking up the LONGEST list against the
SHORTEST list.....something like =VLOOKUP(A1ofLongList,EntireShortList,1,false).... but you are at the mercy of spelling errors, etc. hth Vaya con Dios, Chuck, CABGx3 "Brian Mosher" wrote: I work for a pharmacy and I have 2 spreadsheets in a workbook. One is a list of all of the drugs we have in stock, sheet1. The other, sheet 2, is a list of drugs that we have to do a certain thing with. I need to compare the 2 and pull out every drug that is on sheet 1 AND sheet 2. What would be the easiest way to accomplish this? I use Excel 2000. I know how to use macros, and I know a little VB, but not enough to write something up from scratch. Thanks, Brian Mosher |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I COMPARE TWO SHEETS AND IDENTIFY WHICH CELLS DIFFER | Excel Discussion (Misc queries) | |||
Compare two Sheets with Conditional Formatting | Excel Discussion (Misc queries) | |||
Compare Sheets | Excel Discussion (Misc queries) | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
Compare Side by Side with 3 simulatanous sheets scrolling | Excel Worksheet Functions |