• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

HLOOKUP

The HLOOKUP function searches for a column heading that is defined in the table array and then it returns a number associated with the row index.

=HLOOKUP(lookup_value,table_array,row_index_number,range_lookup)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint