HLOOK UP , VLOOK UP &

1. HLOOK UP , VLOOK UP& PIVOT

2. HLOOKUP • H =........................................................ • LOOK =.................................................. • UP=........................................................ • LOOKUP=............................................... • HLOOKUP=.............................................

3. HLOOKUP • H =MENDATAR • LOOK =MELIHAT • UP=ATAS • LOOKUP=MENCARI • HLOOKUP= MENCARI SECARA MENDATAR

4. RUMUS HLOOKUP • =HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) • Lookup_value    is the value to be found in the first row of the table. • Table_array    is a table of information in which data is looked up. Use a reference to a range or a range name. • Row_index_num    is the row number in table_array from which the matching value will be returned. • Range_lookup    is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

5. CONTOH HLOOKUP • =HLOOKUP(lookup_value;table_array;row_index_num;range_lookup)

6. CONTOH HLOOKUP • =HLOOKUP(lookup_value;table_array;row_index_num;range_lookup)

7. CONTOH HLOOKUP • =HLOOKUP(lookup_value;table_array;row_index_num;range_lookup)

8. CONTOH HLOOKUP • =HLOOKUP(lookup_value;table_array;row_index_num;range_lookup)

9. CONTOH HLOOKUP • =HLOOKUP(lookup_value;table_array;row_index_num;range_lookup)

14. VLOOKUP • V =VERTIKAL • LOOK =MELIHAT • UP=ATAS • LOOKUP=MENCARI • HLOOKUP= MENCARI SECARA VERTIKAL

15. RUMUS VLOOKUP • VLOOKUP(lookup_value;table_array;col_index_numrange_lookup) • …….. • …….. • Col_index_num    is the column number in table_array from which the matching value must be returned • …….. • ……..

16. CONTOH VLOOKUP VLOOKUP(lookup_value;table_array;col_index_num;range_lookup)

18. PAKDE