Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/05/If-Percentage-is-in-range.xlsx

In this Microsoft Excel video tutorial I demonstrate how to conditionally return a value if a percentage is within a range. In my example we want to grade students based on the percentage of an exam that they completed correctly. There are multiple ranges and grades within which I need to find a particular student's percentage mark. Instead of using a complicated nested IF or IFS formula we can use a much simpler VLOOKUP or XLOOKUP.

00:00 Introduction
00:19 VLOOKUP - Exact match or next smaller item
02:42 XLOOKUP - Exact match or next larger item