How do I return a value from a column based on info from neighboring columns?
I have a table of data that looks similar to this:
Weight | Name | School | Division |
---|---|---|---|
106 | Name1 | School1 | 1 |
106 | Name2 | School2 | 2 |
106 | Name3 | School3 | 3 |
106 | Name4 | School4 | 4 |
113 | Name5 | School5 | 1 |
113 | Name6 | School6 | 2 |
113 | Name7 | School1 | 3 |
113 | Name8 | School3 | 4 |
It's a very large table, so there will be multiple matches for Schools, and occasionally a few matches for Names, but there will always be only one match for a given Weight and Division.
In a separate table, how can I get the name of the person associated with the unique weight and division?
In my head, the formula goes" "Look in the Weight column to find 106, then look in the Division column to find 4, then return the value from the Name column." But I can't figure out the formula that will do that.
Any thoughts?
MacBook Pro, OS X Yosemite (10.10.2), Numbers 3.5.2