Welcome to the community, Timothy! To begin with, Airtable formulas don’t currently work across tables (what you called worksheets). They only work within a single table. To share data between tables requires at least one field that links records between the relevant tables, along with some combination of either rollup and/or lookup fields.
Before going further, I have a question about your desired setup. Say in
[Table 1] you’ve got “apple” assigned a point value of 5, and “pear” a value of 10. In
[Table 2] you enter “apple” into the entry field, and I’m assuming you want the value 5 to appear in the field next to it. But what happens if the entry field contains “apple pear”? Should the value in the adjacent field be 15, the sum of the point value for both words?
I ask because finding a single match against a reference table, and connecting that to a single point value, can be done with a little work (I’ve done it). However, finding all possible matches, and adding all relevant point values, is a whole different story. I can’t think of a way to do it using a reference table like you describe. Even within a single table, Airtable doesn’t have the means in a single formula to perform multiple matches and connect each match with a unique value, then total all the found values. The only solution that comes to mind involves a host of individual formula fields—one to check for each word/phrase and return the resulting point value (or zero if not found)—and a final formula field to add all values, at which point the reference table is useless.