Ada yang harus kita perhatikan ketika bekerja dengan fungsi (function) dalam OpenOffice.org. Kebetulan ini yang baru dialami, mungkin masih banyak lagi yang harus dieksplorasi sehingga akan diperoleh sesuai dengan harapan kita.
=vlookup() –> Vertical Look Up Function, untuk menghasilkan informasi berdasarkan data yang tersedia.
Fungsi ini tidak akan sederhana, jika kita ingin menghasilkan informasi secara “akurat”. Jadi option yang penting untuk diperhatikan ketika memakai vlookup function adalah “accuracy”.
This is the cell reference to the table we want to work with. In this case it is the area A1 to B100. As you see, the names are given in the left column, and the =VLOOKUP() formula will always search in the left column of any table. This is important.
The reason for typing B100, which is obviously too far down, is to make sure that if we add more data here, it will be included in the formula. Data enteret in cell A101 and B101 will not be considered by the formula. It is, by the way, not required that you include the column headings, like I’ve done here.
If Calc is able to find what you wanted to search for, where you wanted to search for it, you need to specify exactly what information you want in return. In this case, we specified that we wanted the related information from column number 2 in the table. Notice that the number is totally unrelated to the cell reference itself — of the same table was placed in the columns F and G, the reference number for the feedback would still be number 2, as it refers to the table you defined in the green area.
OK, to be more accurate it really means sorted or not sorted… If it says “1“, it means that the list is sorted, and will give you the closest match to what you searched for. You will probably never use that in you entire life, so I suggest that you consequently use “0” instead, which requires a perfect match. If it doesn’t find a perfect match, it will show an error message: “#N/A“.
Yang dibahas disini adalah masalah “accuracy“, karena ada “ketidakpuasan hasil” yang diperoleh apabila tidak memakai option “accuracy” .
Jika saya ada kekeliruan, mohon kasih comment… terima kasih.
sama ko di excel juga,.. kalo ngga salah..
soale udah lama ngga pake excel..
ada accurracy,.. nilainya sebagai boolean.. true atau false..
Oke terima kasih, sangat membantu….kalo ad tips n triks di calc bole ikutan lagi !
Kalo vlookup-nya antar file bagaimana ya?
kalo mau ambil data dari sheet yang berbeda dalam satu file dgn fungsi Vlookup, Caranya bagaimana?