Hey all,

I am tweaking a spreadsheet that needs to look up the minimum number of a list of numbers that belong to a particular item and number. For example:

Bottle # Drug Code Drug Name
1292 BUP Buprenorphine 0.3mg/ml
1293 bup Buprenorphine 0.3mg/ml
1294 bup Buprenorphine 0.3mg/ml
35 BupR Buprenorphine 0.3mg/ml

I am using the Dmin function to do this as the lowest number must be tied to the drug name (so I can detect the lowest bottle number of buprenorphine, or the lowest bottle of another drug).

It works fine but there is a problem when another drug code containes what I am searching for. In the example above, my dmin is looking up the lowest bottle number for "BUP", and it returns "35", I assume because BupR containes "BUP". Is there a way to make this specific for what I am looking for?