If you are using Excel 2019 or later, it is worth your while to learn XLOOKUP. It is a little easier to use and get used to. It is nice too, that it defaults to the exact match. =XLOOKUP(A2,$D$5:$D$8,$E$5:$E$8) Fill down to the other cells. Or, do them all at once with: =XLOOKUP(A2:A25,$D$5:$D$8,$E$5:$E$8)