![]() ![]() The third argument, row_index_num is the row number in the table from which to retrieve a value. The second argument, table_array, is a range that contains the lookup table. The first argument, called lookup_value, is the value to look up. Use VLOOKUP when lookup values are located in the first column of a table. Use HLOOKUP when lookup values are located in the first row of a table. When it finds a match, it retrieves a value at that column from the row given. HLOOKUP searches for a value in the first row of a table. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for finding partial matches. Like the "V" in VLOOKUP which stands for "vertical", the "H" in HLOOKUP stands for "horizontal". The lookup values must appear in the first row of the table, moving horizontally to the right. The HLOOKUP function can locate and retrieve a value from data in a horizontal table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |