HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) searches the top row of an array or a table and returns the value of the indicated cell : HLOOKUP « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. HLOOKUP
If Range_lookup is TRUE or omitted, an approximate match is returned. The next largest value that is less than lookup_value is returned.

If Range_lookup is FALSE, HLOOKUP will find an exact match.

If one is not found, the error value #N/A is returned.

Referenced from Excel Help









19.6.HLOOKUP
19.6.1.HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) searches the top row of an array or a table and returns the value of the indicated cell
19.6.2.=HLOOKUP("Name",A1:C4,4,FALSE) search in Employee Name, and returns the value from row 4=HLOOKUP(
19.6.3.=HLOOKUP("Salary",A1:C4,3,TRUE)=HLOOKUP(
19.6.4.=HLOOKUP(3,{1,2,3;"a","b","c";"d","e","f"},2,TRUE) searches 3 in the first row of the array constant, and returns the value from row 2 in same column=HLOOKUP(3,{1,2,3;