Forum Discussion

jakuzi1's avatar
jakuzi1
Copper Contributor
Jan 04, 2025

Need formula help

We have a workbook with a sheet for each month named Jan - Dec.  on each sheet is the date in column A and column B, C, D have text data and column E has numbers. What i need is a formula that gives ...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jan 06, 2025

In the following, I entered only Jan-Mar. You can easily expand this to encompass all 12 months.

=LET(dates, VSTACK(Jan!A2:A32, Feb!A2:A30, Mar!A2:A32), 
     amounts, VSTACK(Jan!D2:D32, Feb!D2:D30, Mar!D2:D32), 
     max_amount, MAX(amounts), 
     max_date, XLOOKUP(max_amount, amounts, dates), 
     HSTACK(max_amount, max_date))

 

Resources