vlookup of a filtered list

Hey Guys,

This may be complicated or not. I'm not too sure.
I have a table in excel that goes from A1:L392
I have 7 headings at the top with one of them being names (last name then first name)
Another heading is account # that is associated with that name.
So when i filter under the names column i get that person then all of the accounts with that name (usually 1-7 rows depending on how many accounts are associated with that name)
I then have another spreadsheet (same file just different page) with information i need to be plugged in automatically from those 1-7 rows

so the second spread sheet will have A1:B8
Name: Account #



I was just going to create a vlookup for each cell (from A2:B8) which will enter the name and the account # for up to 7 names/accounts (could be less)

The problem is, when i filter the data, vlookup will still use the hidden A2 data from spreadsheet1 when i need it to use ONLY the visible data from the filtered table

Any ideas?

Thanks