Vlookup return multiple values horizontally for a list of values

Hi All,

Can someone help me with this?

VLOOKUP RETURN MULTIPLE VALUES HORIZONTALLY FOR A LIST OF VALUES

I attached an example file.

Sheet 1 has the data

Sheet 2 is a list of upcs that i want to look up in sheet 1 and return the UOM data horizontally if it has more then 1 uom.

I tried several times entering a formula but it would not return the correct values.

=IFERROR(INDEX(Sheet1!$B:$B,AGGREGATE(15,6,ROW(Sheet1!$A$2:$A$1203)/(Sheet1!$A$2:$A$1203=$A2),COLUMNS($B$1:B$1))),"") to the right and down

Whoa,

That was my problem i was copy down first then to the right.

Works like a charm!

THank you!

In B2

=IFERROR(INDEX(Sheet1!$B$2:$B$2000,SMALL(IF(Sheet1!$A$2:$A$2000=$A2,ROW(Sheet1!$A$2:$A$2000)-ROW($A$2)+1,""),COLUMNS($A:A))),"")


...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

then copy across and down

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.