jakartalantern.com

Your Shopping Cart




Your Cart is currently empty.

   

You are here: Home Content Computer
Decrease font size  Default font size  Increase font size 
Type somethings in the text box below to begin searching
Custom Search

Computer
VLOOKUP Example E-mail
Written by Administrator   
Thursday, 12 May 2011 13:59

VLOOKUP Example

Contoh VLOOKUP 

Sometimes we area confused how to do vlookup in our excel spreadsheet. Here is a simple example to do vlookup.  Eg. You have a data table in the spreadsheet like this below, and you want to fill Column D (PartyName) from the table Party. The Party table you put it in the same worksheet on the Column H and column I. 

Kadang-kadang kita binggung bagaimana caranya membuat vlookup pada spreadsheet excel kita. Misalnya anda mempunyai data table seperti di bawah ini, dan anda ingin mengisi Column D dengan Nama Partai dari table Partai. Table partai anda letakan pada worksheet yang sama pada column H dan column I. 


A B C D F G H I
1 First Last Partycode PartyName

Partycode PartyName
2 Smith Fred A


A Democratic
3 Robbin William D


B Republican
4 Sentoso Bunyamin C


C Decline To State
5 Glen Sutono B


D American Independent
6 Maria Adelia E


E Conservative

So, the question how to to vlookup on the column D2 - D6 ? It is easy. All you need to do is to put this code "=VLOOKUP(H11;$H$3:$I$7;2;FALSE)" on the column D2 and then copy the column D2 to D3 - D6.

Jadi pertanyaannya bagaimana kita membuat vlookup pada column D2 - D6 ? Caranya mudah, yang perlu anda lakukan adalah memasukkan syntax berikut ini "=VLOOKUP(H11;$H$3:$I$7;2;FALSE)" pada column D2 dan kemudian copykan ke column D3 - D6.

Last Updated on Thursday, 12 May 2011 16:28
Read more...
 
PDF Converter E-mail
Written by Administrator   
Wednesday, 19 January 2011 13:52

PDF Converter Professional 7.0

 PDF Converter Professional 7 is the smarter PDF solution for business users. It provides everything you need to convert, edit, share and create PDF files. It features 100% industry-standard PDF--and the most accurate document conversion to editable formats even from within Microsoft Office and Microsoft Windows.
Last Updated on Wednesday, 19 January 2011 14:12
Read more...
 
Error Transition from COM context E-mail
Written by Administrator   
Thursday, 23 September 2010 05:39

Error Transition from COM context


 

Last Updated on Thursday, 23 September 2010 06:00
Read more...
 
What is IP Address E-mail
Written by Administrator   
Wednesday, 01 September 2010 05:33

What Is An IP Address ?

Apa itu Alamat IP ?


IP Address is stand for Internet Protocol Address.

 

According to Wikipedia, an Internet Protocol address (IP address) is a numerical label that is assigned to devices (printers, routers, modems, etc) participating in a computer network that uses the Internet Protocol for communication between its nodes. An IP address serves two principal functions: host or network interface identification and location addressing. Its role has been characterized as follows: "A name indicates what we seek. An address indicates where it is. A route indicates how to get there."

Last Updated on Wednesday, 03 November 2010 10:23
Read more...
 
How to open .ISO file ? E-mail
Written by Administrator   
Tuesday, 24 August 2010 11:18

How to open ISO File ?

Bagaimana caranya buka file .iso ?

 

 An ISO image is an image of files that can be burnt to a CD. If you’ve just downloaded an ISO file, and be able to open the ISO file and edit its contents, before burning it off on a CD, here’s a quick guide telling you how you can open an ISO file.

Sebuah image ISO adalaha sebuah image files yang dapat di burn ke sebuah CD. Jika anda baru saja mendownload sebuah file ISO,  dan dapat membuka file ISO dan mengedit isinya sebelum di burn k eke CD. Ini ada caranya bagaimana anda dapat membuka sebuah file ISO.
 

Last Updated on Thursday, 04 November 2010 05:46
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 Next > End >>

Page 1 of 8


KutuBuku


Masukkan Code ini K1-AC7Y11-2
untuk berbelanja di KutuKutuBuku.com