How to VLOOKUP multiple criteria

In Excel you can lookup a value using the VLOOKUP formula. Things get tricky if you want to do a lookup based on more than one value, but this is fairly easy in Easy Data Transform.

For example if you have a list of orders with product code and supplier code in separate columns in one sheet:

VLOOKUP multiple criteria

And you want to lookup the description corresponding to each product code and supplier code pair in another sheet:

VLOOKUP multiple criteria example

You can do this very quickly and easily with Easy Data Transform. You just need to create helper columns that concatenate the two columns in each sheet and then do the lookup using the helper columns.

VLOOKUP multiple criteria tutorial

VLOOKUP multiple value

VLOOKUP multiple columns

VLOOKUP two values

VLOOKUP two criteria

VLOOKUP two columns

VLOOKUP 2 criteria

Excel VLOOKUP multiple criteria

Excel VLOOKUP alternative

You can add a Remove Cols transform if you want to remove any columns (e.g. the new helper columns) before output.

Concat Cols and Lookup are just two of the 50 transforms that Easy Data Transform supports.

Try it free now!

Windows Logo Windows Download

v1.15.1 for Windows 10 / 8 / 7 (31 MB)

Apple Logo Mac Download

v1.15.1 for Mac 11.x to 10.13 (32 MB)

Questions or problems?


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

This pop-up will not be shown again