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 etcHow I can make Google Sheets automatically populate in column B the points associated with the action selected from the dropdown menu in column A?
How can I change the value of one cell in Google sheets based on what is entered into another?
google spreadsheets