How To: Writing Index, Match and Index, Match, Match formulas

Writing a formula in Excel can be tricky, especially if you plan on writing one that has a bit of length to it and the INDEX and MATCH functions are no exception. There are a couple of things to keep in mind when writing formulas that will make it much simpler. Consider the following data:   …


The Long Road: Problems with hyperlinking Office Documents in Excel

When you create a hyperlink to another Office document in Excel 2007 or 2010 and click to follow that hyperlink, you expect the document to open. In some cases, however, you may receive an error: “Cannot locate the Internet server or proxy server”. A quick BING search reveals KB Article 218153 (http://support.microsoft.com/kb/218153). This article directs…