display multiple results with vlookup

[chriswrcg]

I was wondering how to get vlookup to show more than one result. I have a map of my warehouse and yard in a workbook. I can display what type of trailer is on the yard and where it is at with vlookup. in the cell under that one i want to display the parts in that trailer. this is simple when the total number of parts is on in the trailer but more difficult when the trailer has more than one sku. how do i get vlookup to display all the parts in the trailer at once?
i have got vlookup to display the first item and the last item in the trailer by switching true or false but it ignores all the other parts.

[LokeshKumar]

Could you upload the sample workbook..

[AliGW]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[chriswrcg]

here is an example. I want dock door 3 to display products 1 through 4 in the cell instead of just product 4

[José Augusto]

Hi
Try this in Sheet1!A2

Please Login or Register  to view this content.

and copy right and down

See the file Book1sample.xlsx

[Tony Valko]

Try this...

Data Range

	A	B	C	D	E	F	G
1	dock door 1	dock door 2	dock door 3			dock door 1	product 1
2	product 1	product 2	product 1			dock door 2	product 2
3			product 2			dock door 3	product 1
4			product 3			dock door 3	product 2
5			product 4			dock door 3	product 3
6	------	------	------	------	------	dock door 3	product 4

This array formula** entered in A2:

=IFERROR(INDEX($G:$G,SMALL(IF(Sheet1!$F$1:$F$6=A$1,ROW(Sheet1!F$1:F$6)),ROWS(A$2:A2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to C2 then down until you get a row full of blanks.

Note that the entry in cell F1 had a trailing space character in it.