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 |
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 |
All times are GMT +1. The time now is 03:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com