HLOOKUP « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial

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.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;