INDEX MATCH the easy way

Question

I've created a short video on how to use a trick to create INDEX MATCH formula quicker.

Also, my suggestion for a revised version of INDEX MATCH is now at number 6 (as at 22nd Sep 2016) in the most voted for improvements to Excel.

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/14049132-make-a-simple-safer-version-of-vlookup-and-index-m

nolan tripp · Answer

Great tip! I thought it was neat when I learned to add things like "Property, Plant, and Equipment" (ppe) but it never occurred to me to do the same thing with formulas.

kevin lehrbass · Answer

Very cool trick Wyn. Do you have any other auto-correct formula templates?

wyn hopkins · Answer

Thanks&nbsp;Kevin Lehrbass,&nbsp;I also use autocorrect for certain pieces of power query code&nbsp;e.g. To get a named range as a parameter I use &nbsp; &nbsp;pqname &nbsp;which autocorrects to&nbsp;Parameter = Excel.CurrentWorkbook(){[Name="DefninedName"]}[Content]{0}[Column1],&nbsp;&nbsp;The other 2 things that save me a lot of time are a default template and a toolbar that I developed. &nbsp;Both are free (you can even make up an email address when prompted, it just downloads anyway). &nbsp;&nbsp;https://accessanalytic.com.au/free-excel-stuff/free-excel-templates/&nbsp;&nbsp;

Forum Discussion

INDEX MATCH the easy way

Share

Resources