Vlookup return multiple items in row horizontly

[mohdamir1989]

Dear All,

I have gone through the web and found very useful working samples/examples for my query in which they used index small row and combination of such formulas. but as noob I couldn't figure out the logic and resulted in no solution for my problem.

I have bunch of data in sheet "Daily Feedback" which I want to lookup in "Material Cosumption" sheet, if I put B2 of "Daily Feedback" in A2 of "Material Consumption" it should return AG to BB Values of "Daily Feedback" Sheet ignoring the blanks in between.

Thanks in advance.

Best Regards

 

[estevaoba]

Array enter this (Ctrl+Shift+Enter keys simultaneously) and copy down until it results blanks:

[TABLE="width: 64"]
<tbody>[TR]
  [TD="width: 64"]=IFERROR(INDEX('Daily  Feedback'!$B$2:$BB$100,MATCH($A$2,'Daily  Feedback'!$B$2:$B$100,0),SMALL(IF('Daily  Feedback'!$B$2:$B$100=$A$2,COLUMN('Daily  Feedback'!$AG$2:$BB$100)-1),ROWS($1:1))),"")[/TD]
[/TR]
</tbody>[/TABLE]

Adjust ranges accordingly.