I upgraded my old (though still robust) Dell Inspiron 15 to Windows 8 over the weekend. I’ve struggled quite a bit since then to get it up and running and finally ended up resetting my computer. It has been stable since then and the operating system is definitely faster than Vista and Windows 7.
Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.
If you haven’t had a chance yet, please go through the VLOOKUP tutorial. Alternatively, if you’re ready to jump right into INDEX/MATCH, then let’s get started.
Firstly, create the above table in Excel. I’ll be using Excel 2010 in my example. You can also download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet with the answers.
If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.
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. So whip up the installation of Excel you have. You can use either of Excel 2003, Excel 2007 or Excel 2010. I’ll be using Excel 2010 in my example. Download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet as well.
If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.
VLOOKUP is the easier function of the two to use and understand. It takes just 4 parameters and we’ll be using all 4. And, we’ll look at 4 options of using VLOOKUP.
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!
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.