Company
The Ultimate Add-in to Supercharge your Excel Productivity
Resources
Quick Links
Company
EasySheet Pro
VLOOKUP
This feature provides an enhanced version of VLOOKUP with automatic key column detection (EasyHeadr™ Engine) and intelligent data searching across different sheets. It is accessed from the EasySheet Pro ribbon.
Notes
Key column identification is fully automatic
Automatic identification requires consistent data in key columns
Data search works across different sheets and files
Columns do not need to be adjacent
Column names can differ between the two files
Leading and trailing spaces are ignored in comparisons
Before using this function in critical work environments, it is highly recommended to test it on a non-essential dataset
EasySheet Pro - 2025
EasySheet Pro - 2025
Automatic Column Identification
Automatically finds the best key column in the destination sheet
Identifies the corresponding column in the source sheet by analyzing data
Reduces human errors in column selection
Allows inserting new data into already populated columns without deleting existing data, preserving previous information
Handling Missing Values
Leave blank
Show "N/A"
Keep the original value
This criterion ensures that new data can be inserted without overwriting existing values, preserving original information
Result Placement
Next to the original data
In a new sheet
In a custom location (user-specified column)