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

Nokia 7705 Twist

-
Image
Oh, Ah now this one is real eye-candy. Though a bit unusual but interesting design from Nokia. the 7705 Twist offers a singular design for a cell phone. It's perfectly square (2.71 inches by 2.71 inches by 0.59 inch), but the rounded corners make it look only slightly less angular. So let have a look Nokia 7705 Twist specifications: Network Type CDMA dual band (800/1900 MHz) Data CDMA2000 1xRTT/1xEV-DO rev.0 3G Capable Yes Size Dimensions 2.71 x 2.71 x 0.59 inches (69 x 69 x 15 mm) Weight 3.44 oz (98 g) Battery Type Li - Ion, 860 mAh Talk 4.5 hours (270 mins) of Talk time Standby 312 hours (13 days) of Stand-by time Camera Resolution 3 megapixels Resolution Video Yes Features Flash: Yes, Digital zoom, Self-timer
Read more