I have a work book, lets call it "Addresses", in this work book I have two
worksheets lets name them "A" & "B". In worksheet "B" I have a listing of
employee names and addresses, example:

A1 A2 A3 A4
A5 A6 A7
Location code / employee name / address 1 / address 2/ city / state / zip

each of the above is in a seperate cell in worksheet "B". I want to be able
to enter the location code in one cell, (say A2) of worksheet "A" and then
have the corresponding employee name, address, etc. pull over from worksheet
"B".

I know I can use a VLOOKUP, to do this but the problem i run into is when
there are multiple employees for the same location code. I need all the
employees to somehow pull over, the vlookup will only give me the first one
listed.

Can anyone out there help me with this problem?? I could really use some help.