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]) ...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.