Excel Tutorial: VLOOKUP primer
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.
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.
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 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.
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 unveiled it’s new tablet titled “Surface”. Aptly titled because the Windows RT version weighs in at 676g and is only 9.3″ thick!
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.
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.
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!
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 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.
Micrsoft has just released the Internet Explorer 8 Language pack for Windows Vista and Windows Server 2008. This pack allows you to install specific resource files which will users to view the user interface of IE8 in various supported languages. Individual language packs are available in the following languages, Arabic, Bosnian (Cyrillic), Bosnian (Latin), Bulgarian, Catalan, Chinese (Traditional), Chinese (Simplified), Chinese (Hong Kong), Croatian, Czech, Danish, Dutch, Estonian, Finnish, French, German, Greek, Hebrew, Hindi, Hungarian, Italian, Japanese, Korean, Latvian, Lithuanian, Macedonian, Norwegian, Polish, Portuguese (Portugal), Portuguese (Brazil), Romanian, Russian, Serbian (Cyrillic), Serbian (Latin), Slovakian, Slovenian, Spanish, Swedish, Thai, Turkish, Ukrainian, Vietnamese.
Microsoft has confirmed three new map packs for Xbox 360. This update includes downloadable content packs for Halo 3, Gears of War 2 and Left 4 Dead . The first official release is all set for March 31 and it will be the “SnowBlind” map pack for Greats of War 2.
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.
The form collects name and email so that we can add you to our newsletter list for project updates. Checkout our privacy policy for the full story on how we protect and manage your submitted data!