Category Archives: Excel

Using MATCH and INDEX

Hello. This article is about looking up values¬†in Excel. Balaji¬†asks: How can I create a Query that displays maximum value in one column and the date corresponding to the maximum value in the adjacent column ?   There are several ways to do this. In this video, I will have a look at the MATCH and INDEX formulas to solve […]

Read more