if you use a combo box to selet a drug then vlookup(drug,drug
table,column2,false) will return the strengths and vlookup(drug,drug
table,column3,false) will return dose.This assumes you have a table with all
three variables listed,the drug in say column A,the strengths in B and the
dose in C.
--
paul
remove nospam for email addy!



"Hustler24" wrote:


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