I am having trouble in excel returning multiple occurences in vlookup. i
have tried a few of the examples already solved in this community but i keep
getting errors. I have 2 worksheets and want to search the second worksheet
for all occurences of the value entered in the first worksheet.

e.g worksheet 1
A B C D
1 directive 70220 page 12

worksheet 2
A B C D
1 sweden 70220 page 12
2 sweden 70156 page 13
3 sweden 72254 page 14
4 sweden 70220 page 15

(the user enters "702202"in B1 worksheet1 and i can get the first occurence
of 70220 to return to D1 but not multiple occurences, in this example i would
like to return 12 and 15)

thanks