How to use VLOOKUP to return multiple values

[Acholate]

Hi, I am new to forums

I know this already been asked but I still newbie and can't understand how to modify it to my situation.

I look into these thread but only understand some of the concept.

http://www.mrexcel.com/forum/excel-questions/231882-vlookup-return-all-matches.html
http://www.mrexcel.com/forum/excel-questions/395345-lookup-returns-multiple-values.html
http://www.mrexcel.com/forum/excel-questions/362743-vlookup-duplicates.html


Here is my sample, please take a look.
LookupSample.xlsx

Currently in sheet SOs column B, I using vlookup, which obviously does not work.

I want to return multiple values not just the first one that found.
For example, B3 should return SO560700167 :06/07/2013 instead of SO560700288 :10/07/2013

If someone would provide me an exact formula, I would be very appreciated.

<tbody>
</tbody>

 

[Acholate]

See my reply...

Thank you very much for your formula, I tried it but it still do not work somehow.

B3 still return SO560700288 not SO560700167
It look the same as my vlookup formula, I don't know what when wrong

 

[Aladin Akyurek]

Thank you very much for your formula, I tried it but it still do not work somehow.

B3 still return SO560700288 not SO560700167
It look the same as my vlookup formula, I don't know what when wrong

https://dl.dropboxusercontent.com/u/65698317/aaCopy of LookupSample Acholate.xlsx

 

[Acholate]

https://dl.dropboxusercontent.com/u/65698317/aaCopy of LookupSample Acholate.xlsx

I see now how your formula work, thank you again. But is it possible for you to create formula without change my data from column to row.
Because actually I need to make next column (C) to show customer's name using SO data.
Something like this:

Product Code	Sales Order	Customer Name
F1A-A01-DUSS	SO560700288 : 10/07/2013	ABC
F1A-A01-DUSS	SO560700167 : 06/07/2013	XYZ
F1A-A03-DUSS	SO560700631 : 29/07/2013	ABC
F1A-A03-DUSS	SO560700305 : 11/07/2013	DEF
F1A-A04-DUSS	SO560700073 : 02/07/2013	XYZ

<tbody>
</tbody>

This is the reason why I can't apply the solution which I search from all others thread to my case.

 

[Acholate]

bump

 

[Acholate]

bump

 

[Acholate]

bump...

 

[Aladin Akyurek]

I see now how your formula work, thank you again. But is it possible for you to create formula without change my data from column to row.
Because actually I need to make next column (C) to show customer's name using SO data.
Something like this:

Product Code	Sales Order	Customer Name
F1A-A01-DUSS	SO560700288 : 10/07/2013	ABC
F1A-A01-DUSS	SO560700167 : 06/07/2013	XYZ
F1A-A03-DUSS	SO560700631 : 29/07/2013	ABC
F1A-A03-DUSS	SO560700305 : 11/07/2013	DEF
F1A-A04-DUSS	SO560700073 : 02/07/2013	XYZ

<tbody>
</tbody>

This is the reason why I can't apply the solution which I search from all others thread to my case.

I have already noted that you can't not know beforehand how many times a given entry would occur for being included in the SOs sheet, unless you really repeat each entry (although in partial form) from the source (Solist) in the destination (SOs).

Can you confirm that it's indeed the intent to repeat every entry from Solist in SOs and all are 'DUSS' entries?

 

[Acholate]

I have already noted that you can't not know beforehand how many times a given entry would occur for being included in the SOs sheet, unless you really repeat each entry (although in partial form) from the source (Solist) in the destination (SOs).

Yes Exactly

Can you confirm that it's indeed the intent to repeat every entry from Solist in SOs and all are 'DUSS' entries?

Unfortunately no, there are other entries as well.
I guest I need to show you the full data of my work, please take a look.

stock forecast.xlsx

 

[Acholate]

bump..

 

[Acholate]

bumppp