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?