Company

The Ultimate Add-in to Supercharge your Excel Productivity

logo256 2025-01-06 16_00_47

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

easylogo32

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)

espug-vlook04.jpegespug-vlook03.jpeg