Friday, September 7, 2018

Cara Vlookup beda sheet



Hal-hal yang kecil seperti ini terkadang Suka lupa hehehe..

step1: buat kolom baru di sheet 1
step2: masukan data diinginkan pada sheet 2
step3: buat rumus di kolom baru pada sheet1 sbb:

=VLOOKUP(A3,Sheet2!$A$3:$B$6437,2)

Terima kasih


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Why I should manage master data? (part1)

Because it is used by multiple applications, an error in master data can cause errors in all the applications that used it. For examples, an...