Two sheets, sheet1, sheet2
sheet1 is all text and sheet2 is all numbers, for each text in sheet1, there's a number in sheet2 matching it.
For eg: B5 in sheet1 is "Help", B5 in sheet2 is "100".
Each text appears multiple times and the matching numbers can be different each time.
So, my question is
How to find the sum of the numbers in sheet2 when given the text
Eg: Find the sum of values in sheet2 that match the word "Help" in sheet1.
Thanks a lot!