Kalau ndak salah Mr. Kid pernah menjelaskan secara detail, coba cari di file
milis.
Kalau ndak ketemu boleh ngintip jawaban di bawah ini (saya kutip dari internet).
Syntax
=VLOOKUP(lookup_value,table_array, col_index_num, [range_lookup])
InputArguments
· lookup_value– this is the look-up value you aretrying to find in the
left-most column of a table. It could be a value, a cellreference, or a text
string. In the score sheet example, this would be yourname.
· table_array – this is the table array in which you are lookingfor the
value. This could be a reference to a range of cells or a namedrange. In the
score sheet example, this would be the entire table thatcontains score for
everyone for every subject
· col_index – this is the column index number from which you wantto
fetch the matching value. In the score sheet example, if you want thescores for
Math (which is the first column in a table that contains thescores), you’d look
in column 1. If you want the scores for Physics, you’d lookin column 2.
· [range_lookup]– here you specify whether you want anexact match or an
approximate match. If omitted, it defaults to TRUE –approximate match (see
additional notes below).
AdditionalNotes (Boring, but important to know)
· The match could be exact (FALSE or 0in range_lookup) or approximate
(TRUE or 1).
· In approximate lookup, make sure thatthe list is sorted in ascending
order (top to bottom), or else the result couldbe inaccurate.
· When range_lookup is TRUE(approximate lookup) and data is sorted in
ascending order:
- If the VLOOKUP function can not find the value, it returns the largest
value, which is less than the lookup_value.
- It returns a #N/A error if the lookup_value is smaller than the
smallestvalue.
Regards,HK
On Tuesday, 21 May 2019, 2:46:50 pm GMT+7, [email protected]
[belajar-excel] <[email protected]> wrote:
Terimakasih banyak mas agus, dan mas hendrik, ternyata vlookup bisa di jadikan
sprti ini ya, saya pikir vlookup hanya untuk karakter yg harus sama dengan id
pencariannya,
jika berkenan bisa tolong beri penjelasan tetang vlookup ini mas? soalnya yg
saya tau Vlookup hanya untuk pencarian karakter yang harus sama dengan id
pencarian
Salam, ari
