Excel help please [Closed]

Report
-
Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
-
Ok here's what I want to accomplish.

I want to be able to type the name of a medication: and the formulations automatically appear in the rows following the medication.

Example:

column A Column B Column C Column D Column E
Aspergillus 6 .50 5 .50 4 .50 3 .50
Cat Dander 10 .50 9 .50 8 .50 7 .50

1 reply

Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
143
jenn, Good evening.

Your information is very superficial.
With what you provided us what we can tell you is that the functions Index+Match or VLOOKUP , at first can help you build your formula research.

Save your spreadsheet on a free website, www.speedyshare.com and place the download link here.
This makes it easier to specify an effective solution.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!