Hey all

im not sure what formula i should be using here

what i am trying to do is in J2 is look at sheet Cases that matches up with the data thats in B2 and is the MINIMUM number (if there is multiple cases) and gives me the data thats in column D in cases

im currently using excel 2007 and some computers are using excel 2010 as well

please see example in attached file for more information

test.xlsx