Hi - I'm looking for help building an index match that will help me look up what ranking someone's assignment is (Tab 1) against their stated preferences (Tab 2). Example below:
Tab 1: List of assignments - DESIRED OUTCOME IN THIRD COLUMN
Tab 2: Preference submission (look up here)
Tab 1: List of assignments - DESIRED OUTCOME IN THIRD COLUMN
Name | Assignment | Preference number |
Joe Smith | Baseball | 1st |
Anne Brown | Football | 2nd |
Lisa Jones | Soccer | 1st |
Tab 2: Preference submission (look up here)
Name | 1st | 2nd | 3rd |
Joe Smith | Baseball | Tennis | Soccer |
Anne Brown | Soccer | Football | Tennis |
Lisa Jones | Soccer | Football | Baseball |