So I might be missing something here in what you ultimately are looking for, but take a look at the attached workflow. I created two tables to match your samples. Note in the 2nd table (the Points table), I added another Row as an illustration. Using the Join tool, as you have seen, joining on Function alone will yield duplication of all matching row Point values. Using the Summarize tool, I used the First aggregation function to just call out the Function Area and it's Point Value - not the Sum of all the Points.
The reason for adding in that additional row is to illustrate the concept of matching rows - i.e., if you were only after the Point value, you could simply just output the result of that Point table...however, it would output each and every row regardless if you had any issues in a given area. So the Join tool is important here to isolate the rows where you have matching Function areas, and the Summarize tool will just list the "base" Points when it finds a match, regardless if there is 1 issue or 100 - via the First aggregation action.
