Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we'll use VLOOKUP to find a value from the table. Firstly, let's create the above table in Excel.
Excel Tutorial: VLOOKUP primer
Tag: Microsoft
How to get your Outlook.com email
In the beginning we had Hotmail. I remember creating my Hotmail account way back in 1998 with 10MB and it was considered a lot of space. When Google came out with Gmail, the company revolutionised email as we knew it to be with 1GB of space.
Excel Tutorial: Introduction to VLOOKUP, INDEX and MATCH functions
Excel has several lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.
Upgrade to Windows 8 Pro for only $39.99
If you're already running Windows XP, Windows Vista or Windows 7, then this one is for you! Microsoft is offering all existing users to upgrade to Windows 8 Pro for just $39.99.
Microsoft Surface – Coming soon to a store near you
Microsoft unveiled it's new tablet titled "Surface". Aptly titled because the Windows RT version weighs in at 676g and is only 9.3" thick!
Troubleshooting gets better in Windows 8
Windows 8 has been designed to boot so quickly that you have almost zero reaction time to get to the famous boot screens that allow you to choose a different boot device or enter into the troubleshooting utilities. If you want to enter the boot screens when booting up your PC, you need to hit the F8 key. Usually one tap doesn't suffice and you'll need to hit the key repeatedly several times so that Windows can detect one of them.
7 Steps to gift your mom the best on Mother’s Day
Wondering what to gift your mother this Mother’s Day? Greeting cards, flowers, jewellery and chocolates are all passé; it’s the new age mom we are talking about so the gift should also match her persona. This Mother’s Day make your mom feel special by gifting her a fabulous holiday for her to unwind and get away from the regular boring chores.
Top 7 Stories of the Day
Welcome back to the Top 7 stories of the day! So there's some useful stuff for iPhone, iTouch users; people thinking about upgrading to Windows 7 and Mac Users! 1 - ONE!
Top 7 Stories of the day –
Stuff we'd like to throw into the black-hole, Microsoft's new retail store, how to hack the iPhone (well, not really...), it's all in here!
Microsoft Confirms Motion Controller Project Natal at E3 Expo
Microsoft has recently announced "Project Natal" that will offer motion controller for Xbox 360. At its annual press briefing at the E3 Expo Microsoft finally confirms the rumored motion controller that allows an astoundingly wide range of actions by utilizing a group of sensors. What makes it better is the ability of juggling multiple users during a single session.