Index and Match for Min values

Novice86

New Member
Joined
Jul 18, 2015
Messages
13
I'm looking to create a report when we select a week ending date in cell C6 and to have cells b14 though E14 populate with data from the month selected. I'm able to create the index function for YTD in column G but am struggling with formula identifying minimum week within the selected month for columns through EIn.
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,010
Can you post some sample data, showing how the source table looks like, along with the expected results?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,914
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top