Module 18 : HLOOKUP
18.1 HLOOKUP in Excel The HLOOKUP function is similar to the VLOOKUP function, but it looks for values horizontally (thus, the H), rather than vertically. HLOOKUP searches for a value in the first row of a table. At the match column, it retrieves a value from the specified row. You use HLOOKUP when you want to search across a row to find a value in a specific column in a table. The formula for the HLOOKUP Function is: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) ...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.