Previous Topic Next Topic

Excel help please

Closed
jenn - Jun 30, 2016 at 03:47 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 30, 2016 at 04:19 PM
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
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 30, 2016 at 04:19 PM
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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response