excel index match with formula in a table using headers not working

[leefletcher]

I am trying to do an index/match using column headings in a table where there is a formula creating the information in the lookup array, but I'm getting an error. Table 1 has the First and Last names with a formula to create the full name. Table2 has the Full Name and the school I want to return. If I copy and paste the Full Name over the formula in Table1, the formula in School in Table2 returns the correct School from Table1.

Table1

First Name	Last Name	Full Name*	School
David	Chaudhri	=PROPER([@[First Name]])&" "&PROPER([@[Last Name]])	Bayshore Conservatory
Reinhard	Vinter	=PROPER([@[First Name]])&" "&PROPER([@[Last Name]])	River Valley Institute
Emma	Coeman	=PROPER([@[First Name]])&" "&PROPER([@[Last Name]])	Ravenwood School for Girls
Pharaildis	Christensen	=PROPER([@[First Name]])&" "&PROPER([@[Last Name]])	Bayshore Academy
Phanuel	Barsamian	=PROPER([@[First Name]])&" "&PROPER([@[Last Name]])	Maple Park High School

*I used Proper because the First and Last Names are imported from another source that does not have standard formatting.

Table2

Full Name	School
David Chaudhri	=IFERROR(INDEX(Table1,MATCH([@[Full Name]],Table1[Full Name],0),MATCH(Table2[[#Headers],[School]],Table1[#Headers],0)),"")
Reinhard Vinter	=IFERROR(INDEX(Table1,MATCH([@[Full Name]],Table1[Full Name],0),MATCH(Table2[[#Headers],[School]],Table1[#Headers],0)),"")
Emma Coeman	=IFERROR(INDEX(Table1,MATCH([@[Full Name]],Table1[Full Name],0),MATCH(Table2[[#Headers],[School]],Table1[#Headers],0)),"")
Pharaildis Christensen	=IFERROR(INDEX(Table1,MATCH([@[Full Name]],Table1[Full Name],0),MATCH(Table2[[#Headers],[School]],Table1[#Headers],0)),"")
Phanuel Barsamian	=IFERROR(INDEX(Table1,MATCH([@[Full Name]],Table1[Full Name],0),MATCH(Table2[[#Headers],[School]],Table1[#Headers],0)),"")

Is there a way to pull first and last name together so that the formula works?

 

[RoryA]

The second formula can't create a circular reference if it's in Table2.

 

[leefletcher]

Ok, well, after I copy your data over, it works.

However, I created this spreadsheet from another one that has more private data. It contains the exact same formulas and structure. Any ideas on how I figure out what is wrong with the data?

Thank you, again, for your help.