Rumus Vlookup Hlookup

RUMUS VLOOKUP DAN HLOOKUP

Vlookup :

=VLOOKUP(lookup_value,table_array,column_index_num,[range_lookup])

Contoh: =VLOOKUP(B5;$B$14:SES16;4)

Hlookup : =HLOOKUP(lookup_value,table_array,row_index,[range_lookup]) 

Contoh: =HLOOKUP(B5;$G$13:$I$14;2)

https://1drv.ms/x/s!ArqrtLf3Cm4Xcz0PidonTsLzbE8?e=63bw9T