Compare two lists in Excel LOOKUP and VLOOKUP

Frequently we get a requirement to compare two lists i.e.Determine weather a value in one column exist in  second column or not and viceversa.

Excel provides a very useful function, LOOKUP and VLOOKUP, for this.

Here is complete detail article about this functions with example and pictorial view of it.

http://www.techonthenet.com/excel/formulas/lookup.php

Hope you'll find it useful.

Do you know??

1. People who ride on roller coasters have a higher chance of having a blood clot in the brain.

2. People with blue eyes see better in dark.

3. Money isn’t made out of paper, it is made out of cotton.

... 4. A tiny amount of liquor on a scorpion will make it go mad instantly and sting itself to death.

5. Chewing gum while peeling onions will keep you from crying.

6. A huge underground river runs underneath the Nile , with six times more water than the river above.

7. The USA uses 29% of the world ' s petrol and 33% of the world ' s electricity.

8. Wearing headphones for just an hour will increase the bacteria in your ear By 700 times.

9. The animal responsible for the most human deaths world-wide is the mosquito.

10. Right handed people live, on average, nine years longer than left-handed people.

11. We exercise at least 30 muscles when we smile.

12. Our nose is our personal air-conditioning system: it warms cold air, cools hot air and filters impurities.

13. Our brain is more complex than the most powerful computer and has over 100 billion nerve cells.

14. When a person dies, hearing is usually the first sense to go.

15. There is a great mushroom in Oregon that is 2,400 years old. It Covers 3.4 square miles of land and is still growing.

16. German Shepherds bite humans more than any other breed of dog.

17. The pupil of the eye expands as much as 45 percent when a person looks at something pleasing

18. Men ' s shirts have the buttons on the right, but women ' s shirts have the buttons on the left.

19. The reason honey is so easy to digest is that it ' s already been digested by a bee.

20. It cost 7 million dollars to build the Titanic and 200 million to make a film about it.

21. The sound you hear when you crack your knuckles is actually the sound of nitrogen gas bubbles bursting.

22. The only part of the body that has no blood supply is the cornea in the eye. It takes in oxygen directly from the air.

Beyond Voice, Future of Telecom in India

Beyond Voice, Future of Telecom in India

1) Potential of scale of 3G customer in India is immense but we need service that can do mass interpretation and then there will be no issue of affordability, Issue is relevant content. e.g. people listens calluer tune for just 5-10 secs but currently its 5000 crore business - you need just 10 more such ideas.
Relevant content should be inline with customer profile of Illetrate, multi-lingual etc.

2) In Developed contries - 3G has challenge to replace the large intrepretation of wire internet, but in India - this is not the case, Here interpretation of wire internet is low only.

3) India has Hexagone of youth to empower 3G

4) There is 750M 2G Handset which is going under recycle period like Bajaj, Vespa, Moped etc gone when bikes cames in auto-mobile industry..

Lockmetering for Linux Kernel Performance Measurement and Evaluation and Scheduling

Lockmetering for Linux Kernel Performance Measurement and Evaluation and Scheduling
http://oss.sgi.com/projects/lockmeter/faq.html
http://linuxperf.sourceforge.net/lwesf-duc_vianney-chat.pdf

M.Tech. Admission Procedure in DAIICT,Gandhinagar

...M.Tech. Admission in DAIICT are not based on cast..so all seats are general..

There are four types of specialization in M.Tech.
* VLSI
* Communication Systems (Comm. Sp.)
* Machine Intelligence (MI Sp.)
* Computer Networks (NW Sp.)


There are total 50 seats - VLSI(12) + CS(12) + MI(12) + CN(12) + 2 seats vary based on which specialization is more demanded by students.

A Merit list (around 200 students) is prepared based on the GATE Result of students who have applied for admission.

All students will be asked to present at DAIICT on the day of admission procedure.
Students will be informed about the documents and fees which they have to bring with them.
(Fees will not be accepted by CASH, u have to come with Check or Draft at DAIICT)

Students will be called one by one in the order of their rank in merit list..

He/She will be asked to select in which specialization they want to get admission ?

If the seats in that specialization is available- then ur admission in that specialization is conformed and u need to pay your fees..

otherwise you will asked to choose another specialization in which seats are available.
At that time, if you do not want to go to any other specialization then you will be listed in waiting list of ur current specialization only if u pay the fees at that time. In this case u will be informed later on weather seat is available otherwise u will be given information about how to get refund of ur fees.

If u r 4m computer background then NW or MI will be better..
VLSI will be good for EC students.
If u have strong command on electronic circuit choose VLSI..
else CS will be good for students having command on signal theories.

If u want to cancel ur admission later then u need to inform it to DAIICT then cheque of your refund (usuall 1000 Rs. will be deducated from ur fees) will be send to you within 1 month.

u can mail me (sandip.khakhar@gmail.com) if u still have any questions...

Love Marriage Arranged Marriage Resembles procedural programming language.We have some set functions like flirting, going to movies together, making long conversations on phone and then try to fit all functions to the candidate we like. Similar to object oriented programming approach. We first fix the candidate and then try to implement functions on her. The functions are added to supplement the main program. The functions can be added or deleted. It is a throwaway type of prototype as client requirements rises with time thus it is a dynamic system and difficult to maintain. Requirements are well defined so use of waterfall model is possible Family system hangs because hardware (called parents) is not responding. Compatible with hardware (Parents). You are the project leader so u are responsible for implementation and execution of PROJECT- married life. You are a team member under project leader (parents) so they are responsible for successful execution of project Married life. Client expectations include exciting feature as spouse cooking food, washing clothes etc. All these features are covered in the SRS as required features. Acceptance test possible you can try before you Buy. Product is sold on an as is where is basis. Product once sold will not be taken back! Love Marriage is like Windows, beautiful n seductive.... Yet one never knows when it will crash.... Arranged Marriage is like Unix... boring n colorless... still extremely reliable n robust.

"Nothing bad can happen to us if we're on a plane in India with Sachin Tendulkar on it."
- Hashim Amla, the South African batsman, reassures himself as he boards a flight.

"Sometimes you get so engrossed in watching batsmen like Rahul Dravid and Sachin Tendulkar that you lose focus on your job."
- Yaseer Hameed in pakistani newspaper.

"To Sachin, the man we all want to be"
- Andrew Symonds wrote on an aussie t-shirt he autographed specially for Sachin.

“Beneath the helmet, under that unruly curly hair, inside the cranium, there is something we don't know, something beyond scientific measure. Something that allows him to soar, to roam a territory of sport that, forget us, even those who are gifted enough to play alongside him cannot even fathom. When he goes out to bat, people switch on their TV sets and switch off their lives."
- BBC on Sachin

"Tuzhe pata hai tune kiska catch chhoda hai?"
- Wasim Akram to Abdul Razzaq when the latter dropped Sachin's catch in 2003 WC.

Sachin is a genius. I'm a mere mortal.
- Brian Charles Lara

"We did not lose to a team called India...we lost to a man called Sachin."
- Mark Taylor, during the test match in Chennai (1997)

"The more I see of him the more confused I'm getting to which is his best knock."
- M. L. Jaisimha

"The joy he brings to the millions of his countrymen, the grace with which he handles all the adulation and the expectations and his innate humility - all make for a one-in-a-billion individual,"
- Glen McGrath

"I can be hundred per cent sure that Sachin will not play for a minute longer when he is not enjoying himself. He is still so eager to go out there and play. He will play as long as he feels he can play,"
- Anjali Tendulkar

Question: Who do you think as most important celebrity ?
Shah Rukh Khan: There was a big party where stars from bollywood and cricket were invited. Suddenly, there was a big noise, all wanted to see approaching Amitabh Bachhan. Then Sachin entered the hall and Amitabh was leading the queue to get a grab of the GENIUS!!
- Shah Rukh Khan in an interview.

“India me aap PrimeMinister ko ek Baar Katghare me khada kar sakte hain..Par Sachin Tendulkar par Ungli nahi utha Sakte.. “
- Navjot Singh Sidhu on TV

He can play that leg glance with a walking stick also.
- Waqar Younis

Sachin Tendulkar has often reminded me of a veteran army colonel who has many medals on his chest to show how he has conquered bowlers all over the world. I was bowling to Sachin and he hit me for two fours in a row. One from point and the other in between point and gully. That was the last two balls of the over and the over after that we (SA) took a wicket and during the group meeting i told Jonty (Rhodes) to be alert and i know a way to pin Sachin. And i delivered the first ball of my next over and it was a fuller length delevery outside offstump. And i shouted catch. To my astonishment the ball was hit to the cover boundary. Such was the brilliance of Sachin. His reflex time is the best i have ever seen. Its like 1/20th of a sec. To get his wicket better not prepare. Atleast u wont regret if he hits you for boundaries.
- Allan Donald

On a train from Shimla to Delhi, there was a halt in one of the stations. The train stopped by for few minutes as usual. Sachin was nearing century, batting on 98. The passengers, railway officials, everyone on the train waited for Sachin to complete the century. This Genius can stop time in India!!
- Peter Rebouck - Aussie journalist

"Sachin cannot cheat. He is to cricket what (Mahatma) Gandhiji was to politics. It's clear discrimination. "
- NKP Salve, former Union Minister when Sachin was accused of ball tempering

There are 2 kind of batsmen in the world. One Sachin Tendulkar. Two all the others.
- Andy Flower

"I have seen god, he bats at no.4 for India"
- Mathew Hayden

"Commit all your sins when Sachin is batting. They will go unnoticed coz even the GOD is watching"
- A hoarding in England