How to VLOOKUP between sheets

In Excel you can lookup a value from one table in another table using the VLOOKUP formula. But it can be quite tricky to get the VLOOKUP syntax right, especially if the two tables are in different sheets or different workbooks. There is no syntax to worry about in Easy Data Transform.

For example if you have a list of products with a CategoryID in one sheet:

VLOOKUP between sheets

And you want to lookup the category name from the categoryID in another sheet:

VLOOKUP between two sheets

You can do this very quickly and easily with Easy Data Transform:

Auto run on

VLOOKUP example

VLOOKUP alternative

VLOOKUP alternative

VLOOKUP example

VLOOKUP across sheets

VLOOKUP between files

Lookup is just one of the 66 transforms that Easy Data Transform supports.

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?