Using Google Sheets, I have a dropdown list of different actions, and each action has a different score associated with it.
Eg. Action a = 5 points, Action b = 7 points etc
How I can make Google Sheets automatically populate in column B the points associated with the action selected from the dropdown menu in column A?