Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.
New function in Excel 2016 to display in a cell, the formula contained in another cell
You must have come across a number of situations when you were trying to explain a formula that you have written in Excel and the result of the formula. This kind of situation basically demands both the formula expression and the formula result to be displayed simultaneously. For example, from the below screenshot, if you... Continue Reading →