I just saw a great little video which makes using Excel Index/Match less confusing. This is a post from Wyn Hopkins of Access Analytics in Australia. Note at the end he is using the autocorrect option to fill in the text of the formula right into the cell. Fantastic!!
Welcome to my Blog. I am going to focus on designing workbooks for use in accounting applications to be both expandable and flexible while using all the latest tools that Excel has to offer. Be prepared to rethink the way you do things. Easier formulas to audit, easy to add data without having to copy […]