Accountants' guide to Excel – Excel Tables: Tables and Excel automation part 2

Part 2 of our Accountants Guide to Excel Tables has just been posted to the Excel Community site. As well as looking at how formula columns help Excel automation, the article rekindles the VLOOKUP() v. INDEX() MATCH() debate and shows why a moment's carelessness can cause VLOOKUP() to give completely the wrong answer.

In addition, we ask for your help in righting a great Table wrong by contributing your votes and comments to a long-running campaign on Excel UserVoice.

Anonymous