Hi there

i wanted to make so that once i select the team in cell B12 from the dropdown list and set the number of points given in cell C12 then the final points for the specific team in cells H3:H6 ,depending of the team selected in cell B12, be updated.

ex
Cell B12 = Red
Cell C12 = 50
then the value in cell H3 will be updated to 200


or
Cell B12 = Green
Cell C12 = -70
then the value in cell H5 will be updated to 90

i have attached the image for reference

thank you in advance.

Doido
Screenshot (30).png