WAY TO GET INFORMATION

Rohit Sharma is enjoying a fabulous run towards the end of 2017. After slamming the third double hundred of his career in ODI cricket, Sharma hammered his second T20I hundred on Friday against Sri Lanka. His century, which came off just 35 balls, also saw him equal the record of the fastest T20I hundred. His blitzkrieg innings off 118 were laced with 10 sixes and 12 fours. He was eventually dismissed for 118 (43 balls) by Akila Dananjaya off Dushmantha Chameera on the fourth ball of the 13th over. Rohit’s hundred is also the fastest T20I century by an Indian.  Along with KL Rahul, he added 165 runs for the opening wicket and powered India’s total to 260. David Miller had also achieved the same feat against Bangladesh at Potchefstroom a few months ago. Not only has the Hitman’s innings left cricketing fraternity in awe and wonder but also left Twitterati in a tizzy. Perera: It's a tough series for us. Too big a target to chase. Tharanga and Kusal batted very well, gi...

How to do a vlookup between two spreadsheets If you know the name of a product, for instance, and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process -- but it needn't be. Just follow our step-by-step tutorial to start using VLOOKUP today.  1. Click "Lookup & Reference"  on the Ribbon.   . 2. Click "VLOOKUP"  at the bottom of the drop-down menu.   3. Specify the cell  in which you will enter the value whose data you're looking for. In this case, our lookup value is H2, since this is where we will input the name of a tournament such as "PGA Championship," so we input "H2" in the lookup_value box of the popup window. Once we've set up VLOOKUP properly, Excel will return the tournament's Total Rating Value in cell H3 when we type the tournament ...

 Rohit Sharma scores 208*, first batsman to hit three ODI double hundreds Rohit Sharma stepped into a realm few can hope to enter. His third One-Day International double hundred was a clinical exhibition of punishing batsmanship by a man under pressure to perform. He had lost his first match as captain, failed as a batsman, and had critics breathing down his neck. But one magical knock changed all that. It was cold and gloomy at the PCA Stadium when the toss for the second ODI was taken on Wednesday. Sri Lanka rightly opted to field and it was the only aspect of the game that went in its favour. Rohit and Shikhar Dhawan put the attack to the sword and India ended up with a total of 392. Despite an unbeaten 111 by Angelo Mathews, it was beyond Sri Lanka’s reach and India was home by 141 runs. For Shreyas Iyer too there was much to take home from this contest even though he fell 12 short of a century in only his second ODI. His 213-run second-wicket stand with Rohit, after ...