Lookup value one and retrieve more then one corresponding value fromanother sheet
 

hi,
In my excel sheet1 has value a2:d50
example:

ColA-----------ColB-------------ColC---------ColD

4514012-------01.10.2008----------3pack014------2500
4514012-------15.08.2009----------2fctc012------1850
4514015-------01.02.2009----------3firewood-----2500
4514025-------02.03.2009----------3latex01------1500
so on,
note: Numbers are repeated(ColA)and remaining are difference(ColB,ColC,ColD)

In Sheet 2 has value A2:D50
Example:

ColA-----------ColB-----------ColC---------ColD

4514012-------54140245------1ORIENT01-----200
4514012-------54140325------1MASHTR01-----850
4514015-------54140425------1CSTRAD01-----500
4514025-------54140525------1JANFUR01-----500
so on,
I need following output: In Sheet1 ColE2

4514012-------54140245------1ORIENT01-----200
54140325------1MASHTR01-----850
...
4514015-------54140425------1CSTRAD01-----500
4514025-------54140525------1JANFUR01-----500

please advise me,
thx,


EggHeadCafe - Software Developer Portal of Choice
Developer Productivity as Science and Art
http://www.eggheadcafe.com/tutorials...tivity-as.aspx