VLookup

-
Hi, Previously I wrote about Pivot table, this time lets explore VLookup as this is also one of the very powerful and handy feature of Excel.

First lets understand why we make VLookup. A lot of people use Excel as a database, may be due to reasons like business requirement or unknown to the power RDBMS. Although excel can work as a database, some of the tasks that would be very easy in a database program are fairly complex in Excel. One of these tasks is matching two lists based on a common field; this can be easily accomplished using Excel VLOOKUP. In RDBMS, this concept is more like Primary key that is used to establish relation between two tables. You will find the function VLOOKUP to be extremely useful.

Click here for the fully described example.

Comments

Vipin Vij said…
well irshad, first thanks for regarding by Blog as one of the good blogs. Before accepting and rejecting your request first I would like to know how you will use my blog to promote your things and how my blog can be benefited from it. Tell me all about this, if suits then I have no problems.
November 6, 2008 at 2:24 PM
Post a Comment

Popular posts from this blog

How does dual SIM mobile work

-
Yes we all are busy than ever before. Mobiles were a luxury when launched. Soon became a part if life. What next.. every other person loaded with multiple mobile phones is common these days.. One here one there.. Gosh... But now things are moving to next level.. Enter the world of dual sim phone. You can have two sims running in one phone and switch between services with ease. Read more here..
Read more

My First Post

-
Hi and welcome to my blog.... All are free to express views on any thing related to computer, mobile, cars, bikes, choc lets , science, money, any technology, books and just about any thing........
Read more

What is 3G

-
The other day I went to buy a new mobile phone for my mother. Busy seeing the mobile didn't noticed a girl was standing besides me inquiring about the latest and the most swanky mobiles in the shop. Just then she said to the shop owner that she does not need a 3G bcoz she already have a 3.2 MP camera mobile. To my amaze I thought that world moving to 4G and above and there are people who don't know what 3G is? So, this post is for all those people who want to be familiar about 3G: What is 3G: The high-speed access to voice and data technology is known as 3G service, as it is considered the third generation of cellular telecommunications technology. A 3G network is necessary for this service to function. It offers advancements on the 1G and 2G networks such as multimedia applications like video and broadband services. Minimum speeds for a stationary user is 2 megabits per second. When in a moving vehicle, users get 348 kilobits per second. In ideal conditions, 3G service provid...
Read more