hey all
just trying to find a formula that would work with what im trying to do i hope someone can help me out
what im trying to do is in column J i would like to get the the data that is the minimum (column I) that belongs to the SKU in column B from cases sheet
i have placed a example what i am after on worksheet and a comment on cell J2 in what i am after
hopefully this isnt to hard
i have attached a slimmed down document with a couple of SKUs to work with
we currently use a combination of excel 2007 and 2010 hopefully the formula will work with both versions of excel
thanks in advance
Bookmarks