Main uses of index numbers
Susan Harkins explains how to add an index to a Word document using index tags. Search. You need another tag to include a page number for the Quick Styles main entry. This tutorial shows how to use INDEX and MATCH in Excel and how it is better than VLOOKUP. In a couple of recent articles I made a good effort to explain the basics of VLOOKUP function to beginners and provide more complex VLOOKUP formula examples to power users. And now, I will try if not to talk you out of using VLOOKUP, then at least show you an alternative way to do a vertical lookup in Excel.