Hi,
I've been searching the web, and finally found a formula in mrexcel forum:
http://www.mrexcel.com/forum/excel-q...ml#post2696961
Could anyone here help me to add to this function?
=IF(ROWS(F$2:F2)>E$2,"",INDEX(Value,SMALL(IF(Item=D$2,ROW(Item)),ROWS(F$2:F2))))
It's currently one "item" and one lookup value (D2). I have a total of three "items" and three lookup values...
Also, the values returned should ideally be sorted from largest by one of the "item"-ranges.
Thanks in advance!
Bookmarks