Hi,

I am making a generic spreadsheet for a project that I am doing.

I have linked a list of drugs in one column with the relevant strengths
of tablets of each of these drugs.

I would like to also link the dose of drug required in another column,
so that when I choose a specific drug, I can also choose a relevant
strength and a relevant dose.

For example:

DRUG - Abacavir

FORMULATION - 200mg tablets or 625mg tablets

DOSE - 4mg/kg twice daily.

I am struggling to link the relevant dose to the drug. I have used the
Indirect method to link the drug names and formulations.

Hope you can help!

Thanks.

Michael.


--
Hustler24
------------------------------------------------------------------------
Hustler24's Profile: http://www.excelforum.com/member.php...o&userid=19678
View this thread: http://www.excelforum.com/showthread...hreadid=522531