VLookup

In the Body of the Activity

• Value to lookup - Click Plus on the right side of the field, and then, from the menu, select what to look for using one of the available options:

  • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value to search for.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter the value using the Text Builder.
  • Number - Enter a numeric value.
  • Ask when run - Prompt for a value when the project is executed.
  • Open in Advanced Editor - Enter a VB expression.
• In range - Click Plus on the right side of the field, and then, from the menu, select the range where to search for the value. Select an Excel file, and then a sheet, table, or range, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter a range, table name, or sheet name manually, or Open in Advanced Editor to enter a VB expression.

• Column index - Click Plus on the right side of the field and then, from the menu, select Number and enter the column number containing the value to return. Alternatively, you can use one of the available options in the menu to indicate the column index:

  • Select an Excel file and then a named cell that contains the column number, or select Indicate in Excel to indicate a cell in the column directly from the file.
  • Use Saved Value - Select a numeric value that you previously saved for later use in the project.
  • Ask when run - Prompt for a value when the project is executed.
  • Open in Advanced Editor - Enter a VB expression.
• Exact match - If selected, it indicates you want to return only exact matches. If not selected, approximate matches are returned. This option is selected by default.

• Save to - Click Plus on the right side of the field and then, from the menu, select where to save the result:

  • Select an Excel file and then a named cell, or select Indicate in Excel to indicate a cell from the file.
  • Save for Later Use - Save the result for later use in your project as input for another activity.
  • Open in Advanced Editor - Enter a VB expression.

Properties Panel

• DisplayName - The name displayed for the activity in the Designer panel.

• See the options in the body of the activity.

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

• Output to - See Save to in the body of the activity.