using vlookup to display multiple results

[chapperzz]

Hi,

I have set up a vlookup, which pulls in a row of data from a unique user from a table of results. At the moment my user chooses from a list of exams to display the certain data related to a unique user: =VLOOKUP($B9,results!$A$3:$K$70,3,FALSE)

Choose Exam from List to Display Indv Student Results		Surname	First Name	Student ID	%Score	Result	Grade
Evans L2 Spreadsheet Software MS Excel 2010 Cert UK Eng BCS112893		Evans	Natasha	BCS112893	66%	FAIL	U
Davies L2 Presentation Software MS PowerPoint 2010 Cert UK Eng BCS112894		Davies	Mollie	BCS112894	91%	PASS	A
Davies L2 Presentation Software MS PowerPoint 2010 Cert UK Eng BCS112894		Davies	Mollie	BCS112894	91%	PASS	A
Davies L2 Schools Improving Productivity MS Office 2010 Cert UK Eng BCS112894		Davies	Mollie	BCS112894	82%	PASS	B

<tbody>
</tbody>

What I would like to happen is when the user chooses a particular exam the lookup returns ALL the data relating to a unique user.

Click 1st Column to Display Indv Student Results		Surname	First Name	Student ID	%Score	Result	Grade
Batty L2 Presentation Software MS PowerPoint 2010 Cert UK Eng BCS112896		Batty	Matthew	BCS112896	45	FAIL	U
		#N/A	#N/A	#N/A	#N/A	#N/A	#N/A

<tbody>
</tbody>

The problem I am getting is that other than the first line the results return N/a

The lookup formula for the top line is =VLOOKUP($B$17,results!$A$3:$K$3,3,FALSE), this pulls data from a single row in the table.

The lookup is then changed to select and display the next row of data =VLOOKUP($B$17,results!$A$4:$K$4,3,FALSE)

Is this possible or do I need a different solution?

Thanks

 

[Special-K99]

Why dont you just use Autofilter on the Surname?