How to use VLOOKUP to return multiple values

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Acholate

New Member
Joined
Aug 6, 2013
Messages
26
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 CodeSales OrderCustomer Name
F1A-A01-DUSSSO560700288 : 10/07/2013ABC
F1A-A01-DUSSSO560700167 : 06/07/2013XYZ
F1A-A03-DUSSSO560700631 : 29/07/2013ABC
F1A-A03-DUSSSO560700305 : 11/07/2013DEF
F1A-A04-DUSSSO560700073 : 02/07/2013XYZ

<tbody>
</tbody>

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,165
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 CodeSales OrderCustomer Name
F1A-A01-DUSSSO560700288 : 10/07/2013ABC
F1A-A01-DUSSSO560700167 : 06/07/2013XYZ
F1A-A03-DUSSSO560700631 : 29/07/2013ABC
F1A-A03-DUSSSO560700305 : 11/07/2013DEF
F1A-A04-DUSSSO560700073 : 02/07/2013XYZ

<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

New Member
Joined
Aug 6, 2013
Messages
26
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,813
Messages
5,446,648
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top