I am trying to do the following:

Sheet 1 -

Column A Column B

Dave 44
Dave 19
Dave 27
Dave 16
Dwayne 100
Dwayne 86
Dwayne 32
Dwayne 12

Sheet 1 will have approximately 10 columns of different stats for a USER, and each USER will have approximately 25 rows (1 for each day of the month) Above will give you a rough idea of how this would pan out.

In a seperate sheet I want to pull out the stats for those USERs in an automated way, as you would with a VLOOKUP. But VLOOKUP can only return values for one entry and won't do the rest.

E.g. If I did a VLOOKUP for Dave and then pulled the formula down across multiple rows each row would return 44 (without changing the lookup array)

I need an automated way to pull out all values (1 in each cell) for each user for each row?

Can anybody help?