vlookuphlo见okup-exceltips.pptVIP

HLOOKUP VLOOKUP  -- Excel Tips Liu En En 2008-03-20 HLOOKUP Searches for a value in the top row of a table or an array?of values, and then returns a value in the same column from a row you specify in the table or array. The H in HLOOKUP stands for Horizontal. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) VLOOKUP Searches for a value in the first column of a table array and returns a v