Sum of list 2's values, referencing list 1's item#

Need help Database
1

Ok so I have two lists saved within the DB:
List of texts
List of numbers

I have an RG displaying the list of texts.
What I’m looking to do is reference ‘current cell’s text’ within the ‘list of texts’ and sum the value of each individual text’s corresponding value in list 1 (using it’s item# within the list).

Can anyone help please?

image

2

Are the lists linked to each other in any way? If yes, :group by on list 1 should work.
If they are not linked, first try to establish a relation between them.