Lesson 2 of 4 · 10 min

Essential functions

SUM, AVERAGE, MIN and MAX summarise ranges. IF lets you branch: =IF(B2>50,"Pass","Fail").

XLOOKUP finds a value in one column and returns the matching value from another — the modern replacement for VLOOKUP.

Practice

Build a grade sheet that labels each score as Pass or Fail with IF, then find the top score with MAX.

+50 pts

Backstage grade sheet

A trainee passes when their score in B2 is greater than 50.

1. Build the formula that returns Pass or Fail.

Your formula or code

2. The modern replacement for VLOOKUP is…

HLOOKUPFINDXLOOKUPMATCH

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Practice formulas and charts in a browser spreadsheet.

Free web version · Microsoft account required; desktop features may need a paid plan.