Formula Visualizer
SANDBOX

Learn by watching.

Type any formula and run it. You can also re-sort the data, edit cells, and watch what your formula does.

Double-click a cell to edit it

Drag column letters or rows to re-sort

Press Run — the result updates live

VLOOKUP(
,
,
,)
A
B
C
D
E
F
G
H
1
1
17
19
41
6
12
29
45
2
36
16
16
14
19
13
36
16
3
38
18
47
35
20
7
32
5
4
7
48
27
4
10
9
20
33
5
43
16
38
1
23
48
37
27
6
49
19
11
44
48
9
46
18
7
16
38
7
39
23
3
1
47
8
22
34
16
48
4
10
35
44
Range
8
Lensstandby
Press Run to watch it compute