dimanche 30 septembre 2018

Filling columns based on category and intervals

I have the following problem. I need to fill in the points column based on the Category and score interval. I was trying to do it through the IF function but it seems very complicated. Everytime I try it with the HLOOKUP it also does not seems to work, as I simply don't know how to implement the category selection and interval selection in the formula. Any help would be appreciated!

enter image description here

Aucun commentaire:

Enregistrer un commentaire