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:


VLOOKUP example

VLOOKUP alternative

VLOOKUP alternative

VLOOKUP example

VLOOKUP across sheets

VLOOKUP between files

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

Try it free now!

Windows Logo Windows Download

v1.10.1 for Windows 10 / 8 / 7 (49 MB)

Apple Logo Mac Download

v1.10.1 for Mac 10.15 to 10.12 (24 MB)


Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again