Inputs: 1

What it does: Finds the index of the column the value is found in and appends it as a new column.

How to use it: Choose a beginning column and ending column for the lookup range. Specify a value to search for.

  • Case: Switch on to force the matching to be case sensitive.
  • Names: Switch on to append the name of the column it matches instead of the index of the column.

Did this answer your question?