To find repeated trailer number ? Help

[Jeeves50]

Hi to you all,
I have a spread sheet which populates in cell B2 a trailer number,
This trailer arrives on a bay, for loading. A time stamp for the trailer arriving on the bay is populated in cell C2.
What I need to do is to accumulate the KPIs automatically by looking for the trailer number and retrieving the time that trailer number arrived on bay which is time stamped.
Therefore
Vlookup(b2,range, 2,false) that would find the time stamp. No problem,.

Here is my issue.
The trailer may be put on the bay more than four times in a day, and the vlookup looks only for the first value.
What I need is a way of collecting the all trailer and times that arrive on bay, even if the trailer numbers are the same up to four times in on day.
Could any one help me ?
Regards and thanks
Jeeves50

[RobertMika]

Look here
:http://superuser.com/questions/53623...ultiple-values

[Jeeves50]

Many thanks for you help with this issue, unfortunately this has not quite worked as the formula still searches for the first trailer time.
Could you think of any other formula or macro.
Many thanks
Jeeves 50

[geliedee]

Hi Jeeves50, can you send a sample work book?

[geliedee]

Hi jeeves50,

please see the file. Hope it could help you :d

[Jeeves50]

Thank you for all your help, we have now solved the issue, with the help of all you help, which proves two ,or three minds are better than one.

Regards

Jeeves50

[Tony Valko]

Here's another example:

http://www.excelforum.com/tips-and-t...ml#post3376007