I have two tables and would like to look at values assigned to categories in one table and in another table, only populate the largest value to the same category. For example:
Table1 has the following categories:
1 2
A Apple
B Boy
C Cat
D Dog
Table2 has the same categories with values assigned to them:
1 2
A Apple 15
B Boy 8
C Cat 23
D Dog 4
Is there formula that could look at Table2 and see that Cat has the highest value and then in Table1, only populate cell C2 with 23 (or even an "x"), while leaving the other cells blank? I'm not sure if this is too complex for a formula to achieve.
Table1 has the following categories:
1 2
A Apple
B Boy
C Cat
D Dog
Table2 has the same categories with values assigned to them:
1 2
A Apple 15
B Boy 8
C Cat 23
D Dog 4
Is there formula that could look at Table2 and see that Cat has the highest value and then in Table1, only populate cell C2 with 23 (or even an "x"), while leaving the other cells blank? I'm not sure if this is too complex for a formula to achieve.