Article thumbnail

Excel VLOOKUP Function Trainer Application

Time to read: 1 min

The VLOOKUP trainer applicaiton is implemented via React, Vite, TS, and Tailwind, and deployed to Vercel. Developed for Russian company Action Academy.

The goal is to help to understand a Vertical Lookup or VLOOKUP («вертикальный просмотр», ВПР, in Russian; the applicaiton supports both English and Russian localizations) function in Miscrosoft Excel.

The application is a step-by-step simulator for practicing actions for comparing and searching for missing values in different columns of Excel tables.

Application banner.
Application banner.

Key Features:

Screenshots

Initial invitation.
Initial invitation.
Full application screen view on the Final Stage.
Full application screen view on the Final Stage.
Excel Sheet During Range Selection.
Excel Sheet During Range Selection.
Cells With a Fireworks Indication.
Cells With a Fireworks Indication.
Input Cell With a Fireworks Indication, on a Step Completion.
Input Cell With a Fireworks Indication, on a Step Completion.
Error Tooltip with a Hint.
Error Tooltip with a Hint.
Final Results Column.
Final Results Column.
Misc Correction Toasts.
Misc Correction Toasts.