vlookup function

Is there another function that works like vlookup but will return ALL target values? Vlookup only returns the first instance of ref#

Here's what I'm trying to do:

TABLE1
ref# description hrs
1 05 test 2
25 volume 1.5
2 28 tier 1
3 05 test 2
20 mpo 3
15 volume 1.5

TABLE2
date ref#
10/01/01 1
10/15/01 2
11/18/01 3
11/30/01 2

RESULTS
date ref# description hrs
10/01/01 1 05 test 2
10/01/01 1 25 volume 1.5
10/15/01 2 28 tier 1
11/18/01 3 05 test 2
11/18/01 3 20 mpo 3
11/18/01 3 15 volume 1.5
11/30/01 2 28 tier 1

can someone PLEASE help??