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!