{"id":9126,"date":"2018-07-21T13:41:32","date_gmt":"2018-07-21T11:41:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9126"},"modified":"2023-11-30T20:23:03","modified_gmt":"2023-11-30T19:23:03","slug":"hlookup-function-excel-introduction","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/hlookup-function-excel-introduction\/","title":{"rendered":"HLOOKUP Function in Excel: Introduction"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

Searches for a value in the first row of a table array and returns a value in the same column from another row (downwards) in the table array.<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=HLOOKUP(lookup_value<\/span>, table_array<\/span>, row_index_num<\/span>, [range_lookup]<\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=HLOOKUP(this value<\/span>, in this list<\/span>, and get me value in this row<\/span>, [Exact Match\/FALSE\/0]<\/span>)<\/p>\n

\n

Ever had a horizontal table and you want to search for values in the table easily?<\/p>\n

I’m sure you do!\u00a0 There is a simple way to do this with Excel’s\u00a0HLOOKUP<\/a> function!<\/strong><\/p>\n

This is very similar to the\u00a0VLOOKUP Function<\/a><\/strong>! The only difference is instead of working with vertical tables, you get to do the same thing for horizontal tables!<\/p>\n

Let’s try it out on this horizontal table!<\/p>\n

\"HLOOKUP<\/a><\/p>\n

Using the HLOOKUP function<\/strong>\u00a0let us get the following values from this table:<\/p>\n

    \n
  • What is the\u00a0price\u00a0<\/strong>of a\u00a0television?<\/strong><\/li>\n
  • What is the cost<\/strong> of a\u00a0tablet?<\/strong><\/li>\n<\/ul>\n

    I explain how you can do this below:<\/p>\n

    \n

    Download excel workbook<\/i><\/span>HLOOKUP.xlsx<\/span><\/a><\/p>\n

    \n
    \n

    Table of Contents<\/p>\n<\/span><\/div>\n