Thank you Jennifer and Angela for the help.  I was able to make it work!

Pete

In this scenario, you would use INDEX again, but specify the specific row of student_tbl_2 you're needing to pull down. That looks something like this:

=CONCATENATE(INDEX(student_tbl_2.First_Nam_2, 1)), INDEX(student_tbl_2.Last_Nam_2,1)))

The ", 1" is specifying the first row of that table. For the next row (John Dirt), you would change it to ", 2".

I didn't test this syntax, but I'm pretty sure I got it right.

Hope that helps!