If you reference a number greater than the number of columns in the table array, the function will return the #REF! error.The first column must contain the lookup_valueĬol_index_num (required) - This is the column number of the value you want to find. The table_array must contain at least two columns of data.Table_array (required) - This is the table of data (a range of cells) that VLOOKUP searches to find the information you need. Lookup_value (required): The value to search for in the first column of the table array. The four arguments for the VLOOKUP function are as follows: The VLOOKUP function might look confusing because it contains four arguments, but it's straightforward to use.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |