Adding the Lookup_array for the MATCH Function
This step covers adding the Lookup_array argument for the nested MATCH function.
The Lookup_array is the range of cells that the MATCH function will search to find the Lookup_value argument added in the previous step of the tutorial.
In this example, we want the MATCH function to search cells D5 to G5 for a match to the name of the month that will be entered into cell E2.
These steps are to be entered after the comma entered in the previous step on the Col_index_num line in the VLOOKUP function dialog box.
- If necessary, click on the Col_index_num line after the comma to place the insertion point at the end of the current entry.
- Drag select cells D5 to G5 in the worksheet to enter these cell references as the range the function is to search.
- Press the F4 key on the keyboard to change this range into absolute cell references. Doing so will make it possible to copy the completed lookup formula to other locations in the worksheet in the last step of the tutorial
- Type a comma " , " after the cell reference E3 to complete the entry of the MATCH function's Lookup_array argument.