I am trying to do the following.
I have a list of account numbers in one table. I want to match these account numbers to another big list on a separate tab.
The big list has 8 columns of data and 3779 rows. Under column b is listed the account numbers, but there are more than one account number of the same account. The rest of the data, has IDs, names etc.
What I want to do, is by looking up the account numbers from a small table, to the big list and pull all the information for that one account. i.e pull multiple rows of data for that one account.
VLOOKUP wont work as it will only return one row/one cell data. Not sure how to do this! Doing my nut in.