lookup help

[jharris1981]

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

[Lemice]

Hello and welcome to the forum,

Maybe this formula is what you are looking for
=LOOKUP(2,1/($I2=Cases!$J$2:$J$11)/($B2=Cases!$H$2:$H$11),Cases!$D$2:$D$11)

Paste it on J2 on your Work worksheet and drag it down.

[jharris1981]

Thank you very much Lemice works a treat