Senin, Desember 29, 2008

Just Another VLOOKUP Example

Berikut contoh lagi tentang VLOOKUP (OpenOffice.org 3.0).


B C D E F G H I J
2 Master
Pasien
(sorted)


Tabel

Transaksi
Kunjungan Pasien

3 Kode Pasien Nama Tanggal Lahir

No. Reg.
Kode Pasien Nama Umur
4 101 Gina 04/15/80

1 105 Xanty 26
5 102 Budiyanto 12/05/83

2 103 Fany 26
6 103 Fany 06/03/82

3 108 Arief 25
7 104 Dian 07/09/81

4 104 Dian 27
8 105 Xanty 12/02/82

5 107 Cici Farida 25
9 106 Sinta 12/16/80

6 111 Elin 28
10 107 Cici Farida 01/13/83

7 110 Qarni 26
11 108 Arief 09/03/83

8



12 109 Umar 07/07/82

9
VLOOKUP(H12;B3:D14;2;1)

13 110 Qarni 04/05/82

10

YEARS(VLOOKUP(H13;B3:D14;3;1);NOW();1)
14 111 Elin 10/10/80

12/29/08 NOW()


15