Multiple Criterial Lookup

Hello Advance Formula Users, Although its very simple if you know the trick, it can save HOURS of your time if applied regularly in practice. The trick is basically MULTIPLE CRITERIA lookup with the help of two different methods 1. CONCATENATE and VLOOKUP and 2. INDEX and MATCH. View below video for Detail Recording of the […]


Case Study 1 – Multi Choice Question-Answer Model in Excel

NOTE : There are many interlinked articles for separating basic lesson from this main article. View those links if you want to learn Basics. Hello Excel Modelers, Yes you heard it right. I am sure after going through this article thoroughly, you will gain a great insight on implementing various SIMPLE (simple if you know and […]


Subscribe for Newsletter