I need excell advice please.

%3CLINGO-SUB%20id%3D%22lingo-sub-1339219%22%20slang%3D%22en-US%22%3EI%20need%20excell%20advice%20please.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339219%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20My%20name%20is%20Adam%2C%20and%20I'm%20just%20starting%20to%20get%20back%20into%20Excel.%20I'm%20having%20a%20hard%20time%20finding%20out%20how%20to%20Auto%20Populate%20my%20information.%20For%20Example%2C%20I%20need%20to%20create%20a%20drop%20down%20list%20and%20or%20search%20menu%20list%20of%20different%20medication.%20Once%20I%20use%20drop%20down%20list%20or%20search%20box%20list%20to%20find%20a%20medication%20to%20be%20given%20to%20our%20patients%20%2C%20I%20need%20it%20to%20auto%20populate%20different%20columns%20explaining%20the%20%22common%20Use%20for%20this%20medication%22%20%2C%20and%20the%20common%20%22Side%20effects%22%20of%20this%20medication%2C%20in%20addition%20%22%20recommended%20way%20to%20consume%20product.%20As%20of%20right%20now%20I%20am%20having%20to%20type%20in%20all%20the%20date%20for%20each%20patient.%20This%20is%20taking%20way%20to%20long.%20In%20addition%2C%20because%20I'm%20having%20to%20type%20this%20information%20each%20time%20its%20creating%20significant%20opportunities%20for%20typo%20mistakes.%20I%20the%20option%20of%20selecting%20multiple%20medications%2C%20and%20each%20selected%20medication%20has%20a%20set%20output%20for%20%22side%20effects%22%20%22Common%20use%22%2C%20%22recommended%20consumption%22%20I%20googled%20%22How%20to%20populate%20drop%20down%20list%22%2C%20but%20its%20not%20giving%20me%20the%20information%20I%20need.%20I'm%20really%20hoping%20somone%20can%20lead%20me%20in%20the%20right%20direction.%20I'm%20not%20sure%20how%20to%20word%20the%20information%20I%20seeking.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1339219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339270%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20excell%20advice%20please.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339270%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637641%22%20target%3D%22_blank%22%3E%40adamg4life%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20create%20a%20table%20on%20another%20sheet%20with%20all%20the%20medications%20along%20with%20their%20information%20in%20other%20columns%20and%20then%20you%20can%20use%20VLookup%20formula%20to%20look%20at%20the%20medication%20you%20select%20and%20populate%20other%20columns%20with%20the%20relevant%20information%20as%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20make%20a%20sample%20file%20with%20some%20dummy%20data%20and%20upload%20it%20here%20so%20that%20we%20can%20suggest%20a%20working%20solution.%20Don't%20forget%20to%20explain%20your%20requirements%20based%20on%20the%20sample%20file%20and%20it's%20better%20if%20you%20manually%20mock%20up%20the%20desired%20output%20for%20few%20rows%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339337%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20excell%20advice%20please.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339337%22%20slang%3D%22en-US%22%3E%3CP%3EOkay.%20I'll%20start%20getting%20that%20ready%20for%20you%20right%20now.%20Thanks.%20I%20greatly%20appreciate%20you%20taking%20time%20to%20help%20me%20through%20this%20process.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339346%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20excell%20advice%20please.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3EHere%20is%20a%20blank%20Table%20I%20made%20in%20word.%20I%20would%20like%20to%20create%20an%20excel%20spread%20sheet%20that%20when%20I%20type%20in%20a%20drug%20name%2C%20it%20will%20load%20the%20other%20two%20columns%20automatically.%20I%20need%20the%20ability%20to%20load%20up%20multiple%20drugs.%20As%20of%20right%20now%2C%20I'm%20having%20to%20type%20in%20every%20row%20and%20Colum%20and%20its%20just%20taking%20way%20to%20long.%20I'm%20completely%20open%20to%20any%20program%20that%20can%20achieve%20my%20goal..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%3A%20One%20of%20our%20patients%20needs%206%20medications.%20Part%20of%20our%20care%20plan%20is%20explaining%20exactly%20how%20to%20take%20their%20medication%2C%20what%20this%20medication%20is%20commonly%20used%20for%20and%20what%20the%20side%20effects%20are%20for%20this%20drug.%26nbsp%3B%20In%20word%2C%20I%20created%20a%20basic%20cell%20format%20diving%20each%20criteria.%20I%20have%20to%20manually%20type%20in%20the%20drug%20name%2C%20then%20in%20the%20next%20Colum%20I%20have%20to%20explain%20purpose%20of%20this%20drug%2C%20then%20in%20next%20Colum%20I%20need%20to%20explain%20side%20effects.%20I%20have%20an%20attached%20blank%20copy%20of%20this%20word%20document.%20How%20can%20I%20create%20a%20database%20that%20will%20all%20this%20information%20just%20simply%20by%20typing%20in%20drug%20name%20and%20hitting%20enter.%20Then%20move%20down%20to%20next%20row%20and%20do%20the%20same%20thing.%20ect%E2%80%A6.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone, My name is Adam, and I'm just starting to get back into Excel. I'm having a hard time finding out how to Auto Populate my information. For Example, I need to create a drop down list and or search menu list of different medication. Once I use drop down list or search box list to find a medication to be given to our patients , I need it to auto populate different columns explaining the "common Use for this medication" , and the common "Side effects" of this medication, in addition " recommended way to consume product. As of right now I am having to type in all the date for each patient. This is taking way to long. In addition, because I'm having to type this information each time its creating significant opportunities for typo mistakes. I the option of selecting multiple medications, and each selected medication has a set output for "side effects" "Common use", "recommended consumption" I googled "How to populate drop down list", but its not giving me the information I need. I'm really hoping somone can lead me in the right direction. I'm not sure how to word the information I seeking. 

3 Replies
Highlighted

@adamg4life 

 

You may create a table on another sheet with all the medications along with their information in other columns and then you can use VLookup formula to look at the medication you select and populate other columns with the relevant information as required.

 

Please make a sample file with some dummy data and upload it here so that we can suggest a working solution. Don't forget to explain your requirements based on the sample file and it's better if you manually mock up the desired output for few rows as well.

Highlighted

Okay. I'll start getting that ready for you right now. Thanks. I greatly appreciate you taking time to help me through this process. 

Highlighted

@Subodh_Tiwari_sktneerHere is a blank Table I made in word. I would like to create an excel spread sheet that when I type in a drug name, it will load the other two columns automatically. I need the ability to load up multiple drugs. As of right now, I'm having to type in every row and Colum and its just taking way to long. I'm completely open to any program that can achieve my goal.. 

 

Here is an example: One of our patients needs 6 medications. Part of our care plan is explaining exactly how to take their medication, what this medication is commonly used for and what the side effects are for this drug.  In word, I created a basic cell format diving each criteria. I have to manually type in the drug name, then in the next Colum I have to explain purpose of this drug, then in next Colum I need to explain side effects. I have an attached blank copy of this word document. How can I create a database that will all this information just simply by typing in drug name and hitting enter. Then move down to next row and do the same thing. ect….