Excel 2007 : DMIN Help please!

Bob, I appreciate all your help, and I am closing in on it!

I understand that in the criteria section of my formula I have to have ="=BUP". That fixes my problem if I want to create a report for BUP, but what if I want to do it with another variable, say, ="=MOR"?

My line is: =DMIN(Table2[#All],"Bottle #",'Drug Log'!B2:B3)
B3 is a cell with a value linked to another cell that has a pull down list of all the drugs the user has inputted into the spreadsheet (itself another table). Is there a way to change the cell with the criteria in it, currently ="=BUP" to ="=MOR" when another drug code is selected? I tried inputting ="=B4" but it just gives me "=B4" in the criteria.

The other idea I just had is whether there is a way to generate that criteria statement based on input from another cell. If I enter "MOR" in cell A1, can I get Excel to generate ="=MOR" in cell A2? I think this would work too, and probably be a lot easier. Thanks!