Forum Discussion
I need excell advice please.
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 a...
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.
Okay. I'll start getting that ready for you right now. Thanks. I greatly appreciate you taking time to help me through this process.