I will use VLOOKUP, because I want Excel to look up the values in the ... I've also used "TRUE" for value d, as the score ...
XLOOKUP is a robust tool that overcomes many limitations of VLOOKUP ... lookup_value is the value you’re searching for – lookup_array is the range where you’re searching – return_array ...