Help needed in vlookup second instance

[rishi.ssh]

Hi friends..once again i thank all of you for your warm replies and support to my earlier thread and response to it.

Friends i am little stuck in vlookup when it comes to multiple instance of data with different value but same reference no..i will give you example to explain it better...here i go...
Now in sheet A
i have data as in column A (considere it as reference number)
1111
1111
2222
2222
3333
4444
4444
4444
With corresponding values in Column B as,
2
2
5
7
10
3
4
5

Now the problem is that when ever i try a simple vlookup in different sheet with same Reference no ..just as i quoted above..it returns value as
2
2
5
5(instead of 7 as it reads same reference no so it dosent not return next value)
10
3
3
3


what i want it to return...also the first and second tirst instances of the value...in sheet 1.....
I know its possible...but m nt good at advance formula...can someone..explain me as how can i do this with simple formula
Awating for your kind reply...
My i dont want to return in same row but in same column next to next...thankx

 

[Robert Mika]

Is this what you after:

Excel Workbook
	A	B	C	D
1	*	*	2222	*
2	1111	2	2	5
3	1111	2	*	7
4	2222	5	*	*
5	2222	7	*	*
6	3333	10	*	*
7	4444	3	*	*
8	4444	4	*	*
9	4444	5	*	*
Sheet4

 

[rishi.ssh]

I understood just half the story as it looks a bit complicated to me...i want to return those values in another sheet...which has similar type of data in a column....Can you post some link of any video or simplyfy a little for me to understand it clearly.
thankx..for youe help.

 

[T. Valko]

I understood just half the story as it looks a bit complicated to me...i want to return those values in another sheet...which has similar type of data in a column....Can you post some link of any video or simplyfy a little for me to understand it clearly.
thankx..for youe help.

See if this helps...

Lookup when there are multiple instances of the lookup value

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[rishi.ssh]

Thank alot...i hope i can get through with that.

 

[Robert Mika]

Thank alot...i hope i can get through with that.

You are welcome.