Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and MATCH(lookup_value, range, match_type) Let’s use […]
Cross-referencing is an imposing name for something we’re all familiar with in books, especially reference books. Microsoft Word makes it much easier to do. A cross-reference is simply a mention or link in the text to another part of the same document. In olden days (thirty years ago ) you could put references like these […]
How to print a document when the paper sizes are different. On our new Twitter account we saw this question: “When I send an Excel file to someone, should I have to set it up so they can print? I don’t know the printer/size they use.” Part of that answer is preparing the document but that’s […]
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed amount plus a marginal percentage […]
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper they use. “ It should […]