Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a work book with 2 sheets in.
One has a listing of drugs. Drug Abacavir Sulfate Abelcet Abilify Aciphex Actinex Other sheet has a database listing with a few columns as follows: Description med rec Legend Date ACCUZYME OINTMENT 6237 Y 2-Jun-07 ACCUZYME OINTMENT 6237 Y 24-Jun-07 ACETAMINOPHEN 325 6180 N 16-Jun-07 ACETAZOLAMIDE 250 6247 Y 15-Jun-07 ACETAZOLAMIDE 250 6247 Y 15-Jun-07 ACETAZOLAMIDE 250 6247 Y 20-Jun-07 ACULAR 0.5% EYE D 22216 Y 2-Jun-07 ADOXA PAK 1/150 M 6253 Y 20-Jun-07 What I'm trying to do is check to see if a drug from sheet one is included in any of the test listing on shee 2 under description. The description also includes other description besides the drug name. I would then like to return the med rec# if the drug is found. Any heklp would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Lookup(), VLookup | Excel Worksheet Functions | |||
LOOKUP or VLOOKUP | Excel Worksheet Functions | |||
Double lookup without using vlookup? | Excel Worksheet Functions | |||
Lookup without VLOOKUP? | New Users to Excel | |||
LOOKUP or VLOOKUP | Excel Worksheet Functions |