Hello Dear community,
I use following formula to return name of product based on values. But I think I am doing something wrong, because it is returning same names if values are same.
Can anyone tell me , what I am doing wrong please?
Thanks
Hello Dear community,
I use following formula to return name of product based on values. But I think I am doing something wrong, because it is returning same names if values are same.
Can anyone tell me , what I am doing wrong please?
Thanks
Your formula similar to a simple lookup value in column K in range H:I and returns coresponding name in column I
With "return name of product based on values", what exactly are you looking for?
Extract unique name , sorting on volume Z-A?
PLs try to attach a sample worksheet. (See instruction on yellow banner on top of the page)
Quang PT
I just need to return all matches based on column K to column L
for example K7 is 845, so I need to lookup 845 in column H ( which is row 18 ) and return I18 , but there can be another 845, so I want formula to find next match
With INDEX(SMALL...) Its array formula, need to confirm by Ctrl-Shift-Enter
Alternative by using AGGREGATE:
=INDEX($I:$I,AGGREGATE(15,6,ROW($H$1:$H$40)/($H$1:$H$40=K1),COUNTIF($K$1:K1,K1)))
Thank you very much, can I know what is difference between this formula and array formula?
AGGREGATE(15,6,...) skip the errors from number/0
SMALL(IF(... establish an array, that require Ctrl-Shift-Enter.
Both help to get small value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks