Posted 2/25/2018 11:01 (#6603881 - in reply to #6603653) Subject: RE: Got it!
In column “n” in the corresponding row that I put the treatment I put cost/ml. So it’s Vlookup(h40,$k$2:$L$10,2,false) in the cell in column n. When I pick the drug, it puts in its price per ml in column n, so if I do a multiply formula in column m of g*i*n it gets what I want.