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:
And you want to lookup the category name from the categoryID in another sheet:
You can do this very quickly and easily with Easy Data Transform:
- Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
- Start Easy Data Transform. Make sure the Auto Run button is pressed in.
- Drag the Excel spreadsheet(s) onto Easy Data Transform. If there is more than one sheet in a spreadsheet, you will be asked which sheets to import.
- You should have 2 pink input items. Drag the input items so the sheet you are using to lookup values is vertically below the other sheet.
- Select the two input items using Ctrl+click (PC)/Cmd+click (Mac) (or by dragging a box around them) and click the Lookup button in the Left pane.
- A blue Lookup transform item is added.
- Ensure that the Lookup item is selected. Then in the Right pane set the Top lookup column and Bottom lookup column to the common (‘key’) column and set the Bottom value column to the value you wish to lookup.
- A column of lookup values will then be added:
- You can then click To File to output the results into a new Excel spreadsheet.
- The output file is then created. There is no need to ‘run’ anything.
Lookup is just one of the 66 transforms that Easy Data Transform supports.
Windows Download
Mac Download