Meeting Minutes - automate MM#, author and attendees by date

RiKi

Hi All,

Hope you're all well.

I wanted to filter the meeting minutes based on the selected date. I created hidden columns that contain the meeting number, author and actual attendees for that date. I tried using the formula below but it didn't work. The peach background means this is where I change the date manually, which will then automate the MM#, author and attendees once it matches with the date in the hidden columns. I am using the formula below:

=INDEX([Hidden Cols -->]$2:Duration$4, 3, MATCH([Date Added]$2, [Hidden Cols -->]$4:Duration$4, 0))

I'm not sure what I should have changed.

Paul Newcome

Change your first range to just be a single row (the one you want to pull from) and then change the 3 for the row number in the INDEX function to a 1.

RiKi

240405 MM filter by date_T14_nomatch.png

240405 MM filter by date_T14_nomatch2.jpg

Thanks Paul,

I've put in this code but it results as #nomatch

=INDEX([Hidden Cols -->]$4:Duration$4, 1, MATCH([Date Added]$2, [Hidden Cols -->]$4:Duration$4, 0)) 

t15:

=INDEX([Hidden Cols -->]$4:Duration$4, 1, MATCH([Date Added]$2, [Hidden Cols -->]$2:Duration$4, 0)) 

240405 MM filter by date_T15_nomatch.png

Paul Newcome

You have your ranges backwards.