Table that will show if person has completed particlar training

I'm not clear on what you're asking. Do you want to generate the report from the table or the table from the report?

Put this formula in B2:

Formula:

Please Login or Register  to view this content.

It's an array formula, so you need to enter it with Ctrl-Shift-Enter not just Enter. When you do this, you should see curly brackets {} appear round the formula in the formula bar (don't try to enter them yourself). If you don't see them, click into the formula bar and try again.
Then drag the formula down/right as needed.

The way the formula works is to check if the combination of the name (B1, C1, D1, etc) and training (A2, A3, A4, etc) matches any combination of column A and column B on the Learning History sheet. The combination is done with the concatenation operator '&'. If a match is found, 'Yes' is returned, if not, 'No'.

I've set the ranges for the report sheet as row 2 to row 1000 - if you're going to have more than 1000 rows, then just change the 1000 to a number bigger than you're likely to need.

Hope that makes sense and does what you need.

I think I have this backwards, but since 'Emp Learning History' is the only one with data I entered this in C2 of 'Learning History Rpt' and filled down.

=INDEX('Emp Learning History'!$B$2:$E$4,MATCH('Learning History Rpt'!$B2,'Emp Learning History'!$A$2:$A$4,0),MATCH('Emp Learning History'!B$1,'Emp Learning History'!$B$1:$E$1,0))

	A	B	C
1	Emp	Traing
2	Bob	Tect Training	YES
3	Sue	Tect Training	YES
4	Dave	Tect Training	YES
5	Sue	Del Taining	NO
6	Dave	Del Taining	NO
7	Tom	Del Taining	NO
8	Bob	Time Training	YES
9	Sue	Time Training	YES
10	Dave	Time Training	YES
11	Tom	Time Training	YES

Or is it more like this?

	A	B	C
1	Emp	Traing
2	Bob	Tect Training	X
3	Sue	Tect Training	X
4	Dave	Tect Training	X
5	Sue	Del Taining
6	Dave	Del Taining
7	Tom	Del Taining
8	Bob	Time Training	X
9	Sue	Time Training
10	Dave	Time Training
11	Tom	Time Training	X

Then this?

	A	B	C	D	E
1		Bob	Sue	Dave	Tom
2	Tect Training	YES	YES	YES	NO
3	Del Taining	NO	NO	NO	NO
4	Time Training	YES	NO	NO	YES

In which case try this formula in B2 of 'Emp Learning History' then fill down and across.

=IF(COUNTIFS('Learning History Rpt'!$A:$A,'Emp Learning History'!B$1,'Learning History Rpt'!$B:$B,'Emp Learning History'!$A2,'Learning History Rpt'!$C:$C,"X"),"YES","NO")

You're welcome, glad to be of help and thanks for the rep.

You are welcome. Thank you for the feedback and of course the rep.