|One possible solution:|
Put your Table 1 in B1:E3
Row 1 has your headings, your data starts in Row 2
In A2 enter =B2&D2&E2 which will give you 111
Put Table 2 in B5:D6 (Headings in Row 5, data in Row 6)
The formula to pull the Final Ranking would be:
This will concatenate the 3 pieces of data in Table 2, look that string up in Column A of Table 1 and pull the value from the fourth column of the lookup_array.
You can hide Column A if you want.