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
Am now using this for better time-sheets:
The Full name cells use the LOOKUP formula: