=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 « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =HLOOKUP(3,{1,2,3;"a","b","c";"d","e","f"},2,TRUE). Press Enter to get the result.
Input the formula: =HLOOKUP
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;