Excel Quick Tutorial: Auto Grade with XLOOKUP in seconds You can assign student grades easily with one XLOOKUP formula, no need for multiple IFS conditions. It checks marks against a grade scale and ...