Multiple records, one line on a report

[ronmcnaughton]

I need to read through a file and, using a DLOOKUP, find a specific record for a course taken by a specific employee. There can be multiple records per employee depending on which courses they have taken. (1 record per course)

I need to put all of this on one line of a report.

Any ideas? I thought about trying an array, but I do not know if that would work or exactly how to do it.

Thanks for any help you can offer.
Ron

 

[jbeaucaire]

Without any specifics on your actual dataset, I would recommend adding an INDEX column to make this searching simple. Let's say the employee's name is in Col A and the course name is in column B. You could create a new Col C (and hide it if you wish), that concatenates the two strings together so the row can be spotted in the data. Once you have that, you can pull every remaining cell across to the report by INDEX/MATCH.

Excel Workbook
	A	B	C	D	E	F
1	Name	Class	Index	Date	Location	Complete
2	Jane Doe	Math	Jane DoeMath	1/1/2009	Site1	Yes
3	John Boy	English	John BoyEnglish	1/2/2009	Site2	No
4	Big Bopper	Science	Big BopperScience	1/3/2009	Site3	Yes
Sheet3

Excel Workbook
	H	I	J	K	L
1	Name	Class	Date	Location	Complete
2	Big Bopper	Science	1/3/2009	Site3	Yes
Sheet3