Note: There are other lookup formulas in Excel – such as VLOOKUP and HLOOKUP and these are great. I even wrote an article about Index Match Vs VLOOKUP which sparked a little bit of debate (you can check the comments section for some firework).Īnd today, I am writing this article solely focussed on Index Match to show you some simple and advanced scenarios where you can use this powerful formula combo and get the work done. I am a huge fan of INDEX MATCH combo and I have made it pretty clear many times. INDEX/MATCH is Independent of the Actual Column Position.VLOOKUP cannot work with descending data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |