Many, many thanks WBD! I never would have figured this out without your help.

The version that I think makes the most sense is the one that uses the lookup table because the "dosage" table that is actually used might be slightly different from what I have in the sample data. I'll plug this one into the workbook.

Thanks again!