c (required) is the column index number, and d (optional) is the match mode. In this example, I want Excel to look up the nationality based on the employee ID in cell H4, and return the result to ...

Specify the column index number: Determine which column contains the return value, counting from the first column of your table array as 1. Set the range lookup: Decide whether you need an exact ...

Column_num is the column number in the range that contains the data you’re looking for. The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left).

Column Index Number: This is the column number in the table array from which you want to retrieve a value. The first column is 1, the second column is 2, and so on.

We can illustrate this technique by adding such a validation data control to the Membership Number column as follows: Select all existing data cells in the column in question. In this case, that ...