I'm making an array formula that looks for the lowest positive number in a column, then index matches the description associated with the value.
=INDEX(Sheet5!B:B,MATCH(SMALL(Sheet5!E:E,ROW(1:1)),Sheet5!E:E,0),1)
The formula is pretty much done, I just need the K value in the small formula to look for the smallest positive value. Right now it's returning lowest value, which is negative.
Thanks
Bookmarks