Category: About

Life History of INDEX

About, Formulas, Arrays

Hi there,


Today, while I was browsing through google to learn new techniques on Excel, I have found a great article on INDEX function. Once you read this complete post, you will definitely say thanks to the writer. Further delaying let me share the words of the writer. Makesure you carry a meal and tea to your desk before you start reading this post, because it is bit lengthy. :)


The Excel INDEX function is the single most important in the roster of Microsoft Excel functions.

Now that might be surprising considering the function's humdrum name, but please pay close attention, because INDEX is one of the magical secrets of how to use Excel! So what's so great about the INDEX function? It's nonvolatile, sprightly, agile, and versatile. Excel INDEX can return one value or an array of values; it can return a reference to one cell or to a range of cells. INDEX works well on either side of the three Reference Operators - the colon, the space, and the comma.

Full story »

About Abhilash "exceltoxl" VK

Welcome, About


Is all about a website.

Is all about a blog.

Is all about a forum, what not

'exceltoxl' is an open source to learn, share and experience the new techniques on Excel.


This is a great opportunity for me to say "Hello!" and share/launch my blog This blog is all about the posts on Microsoft Excel. 


Full story »

Contact / Help. ©2020 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.