Learning level
74/100
Product version
1.0.1
Guide status
Stable
Sections
3
VLOOKUP
Implementation-backedUse the lookup function currently implemented by VauSheet and understand its exact-match behavior.
What this guide covers
Syntax
Current behavior
Current scope
Quick facts
Version1.0.1
SurfaceWeb browser
StorageCloud + local checkpoint
ThemeLight · white/orange
Documentation rule: this VauSheet section describes the current implemented product behavior. It avoids claiming full Microsoft Excel parity or live-cursor collaboration where the current build does not provide it.
01
Syntax
Use VLOOKUP(lookup, range, colIndex). The second argument must be a range and the column index must be at least 1.
02
Current behavior
The implementation searches the first column of the normalized rectangular range using a case-insensitive text comparison and returns the value from the requested target column.
03
Current scope
This is not a full Excel VLOOKUP compatibility layer with all optional approximate-match behavior. Use the documented three-argument form for predictable results.
Updated 2 Sep 2026VauSheet 1.0.1