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