Vlookup&hlookup.xlsx

Name Chlorine Florine Hydrogen Bromide Hydrogen Cloride Hydrogen Floride Hydrogen Iodine Hydrogen Water Hidrogen Sulphide Amonia Phosphine Nitric Oxide Nitrogen Dioxide Nitrogen Nitrous Oxide Oxygen Sulphur Dioxide Sulphur Trioxide Carbon Tetrachloride Carbon Tetraflouride Carbon Monoxide Carbon Sulphide Carbon Dioxide Carbone Disulphide Chloroform Formaldehyde Formic Acid Methyl Chloride Methanol Acethylene Vinyl Cloride

Formula Cl2 F2 HBr HCl HF HI H2 H2O H2S H3N H3P NO NO2 N2 N2 O O2 O2 S O3 S CCl4 CF4 CO CS CO2 CS2 CHCl3 CH2O CH2O2 CH3Cl CH4O C2H2 C2H3Cl

CpVapA CpVapB CpVapC CpVapD 26.929 3.38E-02 -3.87E-05 1.55E-08 23.216 3.66E-02 -3.46E-05 1.20E-08 30.647 -9.46E-03 1.72E-05 -6.24E-09 30.291 -7.20E-03 1.25E-05 -3.90E-09 29.061 6.61E-04 2.03E-06 2.50E-09 31.158 -1.43E-02 2.97E-05 -1.35E-08 27.143 9.27E-03 -1.38E-05 7.65E-09 32.243 1.92E-03 1.06E-05 -3.60E-09 31.941 1.44E-03 2.43E-05 -1.18E-08 27.315 2.38E-02 1.71E-05 -1.19E-08 23.228 4.40E-02 1.30E-05 -1.59E-08 29.345 -9.38E-04 9.75E-06 -4.19E-09 24.233 4.84E-02 -2.08E-05 2.93E-10 31.15 -1.36E-02 2.68E-05 -1.17E-08 21.621 7.28E-02 -5.78E-05 1.83E-08 28.106 -3.68E-06 1.75E-05 -1.07E-08 23.852 6.70E-02 -4.96E-05 1.33E-08 16.37 1.46E-01 -1.12E-04 3.24E-08 40.717 2.05E-01 -2.27E-04 8.84E-08 13.98 2.03E-01 -1.63E-04 4.51E-08 30.869 -1.29E-02 2.79E-05 -1.27E-08 23.567 7.98E-02 -7.07E-05 2.45E-08 19.795 7.34E-02 -5.60E-05 1.72E-08 27.444 8.13E-02 7.67E-05 2.67E-08 24.003 1.89E-01 -1.84E-04 6.65E-08 23.475 3.16E-02 2.99E-05 -2.30E-08 11.715 1.36E-01 -8.41E-05 2.02E-08 13.875 1.01E-01 -3.89E-05 2.57E-09 21.152 7.09E-02 2.59E-05 -2.85E-08 26.821 7.58E-02 -5.01E-05 1.41E-08 5.949 2.02E-01 -1.54E-04 4.77E-08

Fungsi VLOOKUP dan HLOOKUP dalam Microsoft Excel berguna untuk membaca suatu tabel, lalu mengambil nilai yang diinginkan pada tabel tersebut berdasarkan kunci tertentu. Kunci ini berupa sel referensi (contoh: sel A2) atau nilai, seperti kode, nomor anggota, nama, dan sebagainya. Jika tabel sumber data tersusun secara vertikal, kita menggunakan fungsi VLOOKUP, Dan, jika tabel sumber data tersusun secara horizontal, maka kita menggunakan fungsi HLOOKUP.

=VLOOKUP(lookup_value,table_array,col_index_num,rang e_lookup)

=HLOOKUP(lookup_value,table_array,row_index_num,ra nge_lookup))

Acethyl Chloride Acetonitril Ethylene Acetaldehyde Acetic Acid Ethane Etanol Ethylene Glycol Propylene Acetone Propane Glycerol Isoprophyl Amine Vinyl Acetylene 1,2- Butadiene 1,3- Butadiene Vinyl Acetat 1- Butene N- Butane Isobutane N- Butanol Isobutanol Ethyl Ether Furfural 1-Pentene N-Pentane 1-Pentanol Methyl-T- Buthyl Ether Chlorobenzene Flourobenzene Benzene Phenol

C2H3ClO C2H3N C2H4 C2H4O C 2 H 4 O2 C2H6 C2H6O C 2 H 6 O2 C3H6 C3H6O C3H8 C 3 H 8 O3 C3H9N C4H4 C4H6 C4H6 C 4 H 6 O6 C4H8 C4H10 C4H10 C4H10O C4H10O C4H10O C 5 H 4 O2 C5H10 C5H12 C5H12O C5H12O C6H5Cl C6H5F C6H6 C6H6O

25.02 20.482 3.806 7.716 4.84 5.409 9.014 35.697 3.71 6.301 -4.224 8.424 -7.486 6.757 11.2 -1.687 15.16 -2.994 9.487 -1.39 3.266 -7.708 21.424 18.196 -0.134 -3.626 3.869 2.533 -33.888 -38.728 -33.917 -35.843

1.71E-01 1.08E-01 1.57E-01 1.82E-01 2.55E-01 1.78E-01 2.14E-01 2.48E-01 2.35E-01 2.61E-01 3.06E-01 4.44E-01 4.18E-01 2.84E-01 2.72E-01 3.42E-01 2.80E-01 3.53E-01 3.31E-01 3.85E-01 4.18E-01 4.69E-01 3.36E-01 2.82E-01 4.33E-01 4.87E-01 5.05E-01 5.14E-01 5.63E-01 5.67E-01 4.74E-01 5.98E-01

-9.86E-05 -4.49E-05 -8.35E-05 -1.01E-04 -1.75E-04 -6.94E-02 -8.39E-05 -8.39E-05 -1.16E-04 -1.25E-04 -1.59E-04 -3.16E-04 -2.83E-04 -2.27E-04 -1.47E-04 -2.34E-04 -8.81E-04 -1.98E-04 -1.11E-04 -1.85E-04 -2.24E-04 -2.88E-04 -1.04E-04 -6.52E-05 -2.32E-04 -2.58E-04 -2.64E-04 -2.60E-04 -4.52E-04 -4.43E-04 -3.02E-04 -4.83E-04

2.22E-08 3.20E-09 1.76E-08 2.38E-08 4.95E-08 8.71E-09 1.37E-09 1.37E-09 2.20E-08 2.04E-08 3.21E-08 9.38E-08 8.35E-08 7.46E-08 3.09E-08 6.33E-08 -1.66E-08 4.46E-08 -2.82E-09 2.90E-08 4.69E-08 7.23E-08 -9.36E-09 -5.48E-08 4.68E-08 5.30E-08 5.12E-08 4.30E-08 1.43E-07 1.36E-07 7.13E-08 1.53E-07

Contoh Penggunaan Vlookup Pencarian Berdasarkan : Name Etanol CpVapA 9.014 CpVapB 0.21407 Pencarian Berdasarkan : Formula C3H6 CpVapA 3.71 CpVapB 0.23454 Penggunaan Hlookup Name Etanol CpVapA 9.014 CpVapB 0.21407

CpVapC CpVapD

-0.0000839 1.3733E-09

CpVapC CpVapD

-0.000116 0.000000022

CpVapC CpVapD

-0.0000839 1.3733E-09

=VLOOKUP(I37;A1:F86;3;FALSE) =HLOOKUP(H47;A1:F86;39;FALSE)

Aniline 1-Hexene N- Buthyl Acetate N-Hexane Benzonitrile Benzaldehyde Bezoic Acid Toluene Benzyl Alcohol 1- Heptene N- Heptane Styrene 1- Octene N- Octene Buthyl Ether Ethyl Benzoate Isopropyl Benzene N- Nonane Naphtalene 1- Octadecene N- Octadecane N- Nonadecane

C6H7N C6H12 C6H12O2 C6H14 C7H5N C7H6O C 7 H 6 O2 C7H8 C7H8O C7H14 C7H16 C8H8 C8H16 C8H18 C8H18O C9H10O2 C9H12 C9H20 C10H8 C18H36 C18H38 C19H40

-40.516 -1.746 13.62 -4.413 -26.004 -12.142 -51.292 -24.335 -7.398 -3.303 -5.146 -28.248 -4.099 -6.096 6.054 20.67 -39.364 3.144 -68.802 -11.329 -14.47 -15.491

6.38E-01 5.31E-01 5.49E-01 5.82E-01 5.73E-01 4.96E-01 6.29E-01 5.12E-01 5.48E-01 6.30E-01 6.76E-01 6.16E-01 7.24E-01 7.21E-01 7.73E-01 6.89E-01 7.84E-01 6.77E-01 8.50E-01 1.66E-01 1.72E-01 1.81E-01

-5.13E-04 -2.90E-04 -2.28E-04 -3.12E-04 -4.43E-04 -2.85E-04 -4.24E-04 -2.77E-04 -3.36E-04 -3.51E-04 -3.65E-04 -4.02E-04 -4.04E-04 -4.20E-04 -4.09E-04 -3.61E-04 -5.09E-04 -1.93E-04 -6.51E-04 -9.37E-04 -9.59E-04 -1.02E-04

1.63E-07 6.05E-08 -7.91E-10 6.49E-08 1.35E-07 5.17E-08 1.06E-07 4.91E-08 7.77E-08 7.61E-08 7.66E-08 9.94E-08 8.68E-08 8.86E-08 8.08E-08 5.06E-08 1.29E-07 -2.98E-08 1.98E-07 2.05E-07 2.08E-07 2.21E-07

Pada gambar tersebut fungsi MATCH mencari posisi relatif dari "Nama 4" pada range A2:A8 hasilnya adalah 4.

Rumus Gabungan Fungsi Index and Match : =INDEX(C2:F86;MATCH(I97;B2:B86;0);MATCH(H98;C1: F1;0))

Contoh Penggunaan Gabungan : INDEX - MATCH Pencarian Berdasarkan : Name 1- Octadecene

Rumus Gabungan Fungsi Index and Match : =INDEX(C2:F86;MATCH(I97;B2:B86;0);MATCH(H98;C1: F1;0))

Formula C18H36 CpVapD 2.0486E-07 Contoh Penggunaan : INDEX - MATCH Pencarian Berdasarkan : Formula C18H36 Parameter CpVapA -11.329 CpVapB 0.16643 CpVapC -0.0009374 CpVapD 2.0486E-07