The Table Array Argument
The table array is the table of data that the VLOOKUP searches to find your information.
The table array must contain at least two columns of data. The first column contains the lookup values (see previous step). These values can be text, numbers, or logical values.
On this line in the dialog box enter the range of cells where the data is located.
As with the lookup value, it is a good idea to use an absolute cell reference for the table array to avoid possible errors when copying the function.
Tutorial Steps
- Click on the table_array line in the dialog box.
- Drag select cells D5 to E10 in the spreadsheet to add this range to the table_array line. This is the range of data that VLOOKUP will search.
- Press the F4 key on the keyboard to make the range absolute.
