![]() ![]() ![]() 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 |