Excellent video article on how to use the LOOKUP function in a multi-table spreadsheet on Apple Numbers:

http://macmost.com/using-multiple-tables-and-lookup-in-numbers.html

https://youtu.be/DMHoOqqr0w0

Am now using this for better time-sheets:

The Full name cells use the LOOKUP formula: