Skip to main content


Showing posts from July, 2013

Looking up for an example on VLOOKUP?

From all the questions I have been asked about and I have asked mostly are related to Excel Formulas If I filter even further I will find that I am looking for information on vlookup most of the times…Here is one attempt from my end to explain what vlookup is all about. What’s VLOOKUP?Ya ya apart from the obvious answer that its an excel formula, it’s a search function!It can find you matching information from a particular table of data – something similar to a hashtable or dictionary in data structures You give it an identifier and it will find the corresponding value for it…Can I get a VLOOKUP Example?Of course! That’s what this blog is about Jokes apart, here is an example of VLOOKUPProblem Statement: Your boss asks you to find out the work experience in number of years of your team matesData you have: Now you have to fill in this table to present it to your boss: Now you’ll get the data in columns H, I from C and D – isn’t it? that’s simple You have a way to do that using VLOOKUP…

Can’t buy free apps on iPad?

I bought the iPad but I was really pissed off that I can’t seem to  buy any free app. I had an apple id, but then it wanted me to give my credit card details to download a free app too…Pch!!! So I googled a bit and got this solution…Create an apple id if you don’t have oneNow download the iTunes app on your computerOpen iTunes and follow these steps:Go to iTunes Store under the “Store” category on your left side panelNow go to “Apps Store” on the top panelYou will see “Top Free Apps” on the right side panel (Scroll down if you don’t see)Mouse over any of the free apps listedClick on the app name (Don’t click on the free button shown when we mouse over)Then you will be asked to signin – sign in with your apple idThen you will be asked to “review”Go ahead and select “none” on the payment screenScreen will be similar to this: the free apps download from any of your iOS devices (iPad or i…