Vlookup Question

[gmazza76]

Good Morning,

Is there a way of using a vlookup up to return more than 1 piece of information?

I have a list of Ref Numbers (Column A) and dates (Column B) but the reference number can appear more than once.
I realise if I do a vlookup it will stop the first time it sees the number in that column and select the reference you need next to it.

Is there any formula (which is best) I can use to pick up then by pass the 2nd or 3rd time it is in the column but still bring the other columns infomration in.

I am looking for the number and want to find the 2nd and 3rd dates I have sent info to the customer.

thanks in advance
Gavin

 

[Aladin Akyurek]

E1 houses a reference number of interest.

In E2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($B$2:$B$1000,SMALL(IF($A$2:$A$1000=E$1,ROW($B$2:$B41000)-ROW($B$2)+1),ROWS(E$2:E2))),"")

 

[gmazza76]

thanks for this I will give it a go