I have two tables... The data I am working with, in it's simplest form, can be described as in the tables below... I am trying to determine a formula to return the highest value in Table two, Column 2, for the numbers that are in Table One, Column 1. The numbers in Table One, Column 1 are the same values as those listed in Table Two, Column 1. Essentially, I would like to utilize a vlookup, or index/match, function to lookup the values in Table One Columns 1 & 2 to display the text, or value, in Column 3 Table Two. It essentially summarizes all the parts purchased by airplane number.

Please assist using the tables below!!! Thanks!!!

Table One:
Summary of Parts Purchased Per Airplane
Column 1 Column 2 Column 3
Airplane Number Highest Number of Characters Description of Parts Purchased by Airplane Number
1 (formula determine highest value in Table 2, Column 3) (Display total parts description, based on highest number of characters)
2 "" (Display total parts description, based on highest number of characters)
3 "" (Display total parts description, based on highest number of characters)
4 "" (Display total parts description, based on highest number of characters)
5 "" (Display total parts description, based on highest number of characters)

Table Two:
Purchases by each Airplane
Column 1 Column 2 Column 3
Airplane Number Number of Characters in Column 3 Description of Parts Purchased by Airplane
1 1 a
1 4 a, b
1 8 a, b, c
2 1 e
2 4 e, f
2 8 e, f, g