XLOOKUP Function 2 - Free Excel Practice Online

This free, interactive exercise teaches you XLOOKUP Function 2 in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising XLOOKUP Function 2 this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this XLOOKUP Function 2 lesson

1. What would =XLOOKUP(2021, 1:1, 4:4) return?
2. Write an XLOOKUP to return Wisconsin's sales in 2022. Use "Wisconsin" as the lookup value. Use whole columns for the cell ranges.
3. What would =XLOOKUP("New York", A:A, C:C) return?
4. Write an XLOOKUP to return Wisconsin's sales in 2022. Now use 2022 as the lookup value. Use whole rows for the cell ranges.
5. What would =XLOOKUP(22, F:F, D:D) return?
6. Write an XLOOKUP to return New York's sales in 2024, using "New York" as the lookup value.
7. What would =XLOOKUP(9, 4:4, 1:1) return?
8. Write an XLOOKUP to return the 2023 sales for the state that had 4 sales in 2022. Use 4 as the lookup value, not the state name.
9. What would =XLOOKUP(12, B:B, C:C) return?
10. Write an XLOOKUP to return the state name for the state that had 4 sales in 2022.

XLOOKUP Function 2 practice - FAQ