J
JRD
excel 2007
Look at the example below:
A B
1 Isoket; Reopro; "verapamil" "100MCG"; 11.4MLS; 0.5MLS
2 Reopro; "Isoket"; heparin "7.4ml"; 500mcg; 5000units
3 Isoket; heparin; lignocaine 350mcg; 5000 units; 10mls
Column A contains various medical drugs used in a medical procedure. Column
B contains the dose of these drugs (in the order in which drugs stated in
column A seperated by a semi-colon)
I need excel to pick out from column A the drug reopro if reopro is
contained in a cell in column A then tell me what dose was used by looking in
column B.
So in example above, in row 1 the answer should be 11.4MLS, in row 2, 7.4ml
and in row 3, N/A (i.e. no reopro was used)
Thanks for the help
John
Look at the example below:
A B
1 Isoket; Reopro; "verapamil" "100MCG"; 11.4MLS; 0.5MLS
2 Reopro; "Isoket"; heparin "7.4ml"; 500mcg; 5000units
3 Isoket; heparin; lignocaine 350mcg; 5000 units; 10mls
Column A contains various medical drugs used in a medical procedure. Column
B contains the dose of these drugs (in the order in which drugs stated in
column A seperated by a semi-colon)
I need excel to pick out from column A the drug reopro if reopro is
contained in a cell in column A then tell me what dose was used by looking in
column B.
So in example above, in row 1 the answer should be 11.4MLS, in row 2, 7.4ml
and in row 3, N/A (i.e. no reopro was used)
Thanks for the help
John