vlookup more than one result

[phairplay]

Hello

could you please help me I need a forumla that uses a vlookup to find multiple results for the same part i.e

I have parts that appears more than once all for the same Qty

part	qty	date
apple	100
apple	100
apple	100

<TBODY>
</TBODY>

on another sheet i have the follwoing

part	qty	date
apple	100	03/05/13
apple	100	16/05/13
apple	100	23/05/13

<TBODY>
</TBODY>

what I would like is a vlookup to return the first result then for the second return the second result and so on?

I hope this makes sense.


cheers

 

[venkat1926]

not clear

second sheet

part	qty	date
apple	100	03/05/13
apple	100	16/05/13
apple	100	23/05/13

<tbody>
</tbody>

why no;t just sort whole data acording to thridcolumn ascending.

 

[phairplay]

I have 780 lines with 78 duplicated parts

 

[venkat1926]

I suppose even then sorting will not take time. sort according to part and date.

 

[Robert Mika]

I have 780 lines with 78 duplicated parts

Excel 2010
	A	B	C
1	part	qty	date
2	apple	100	3/5/2013
3	pwar	100	16/05/13
4	apple	100	23/05/13
5
6
7	apple	100	16/05/13
8
9	apple	100	1/1/2012
10
Sheet11

Excel 2010
	A	B
1	Apple
2	3/5/2013
3	23/05/13
4	16/05/13
5	1/1/2012
6
7
8
9
Sheet12

Cell Formulas
Range	Formula
A2	{=IFERROR(INDEX(Sheet11!$C$2:$C$11,SMALL(IF(Sheet11!$A$2:$A$11=$A$1,ROW(Sheet11!$C$2:$C$11)-ROW(Sheet11!$C$2)+1),ROWS(Sheet11!$A$2:$A2))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[phairplay]

Spot on many thanks

 

[Robert Mika]

Spot on many thanks

You are welcome.