Forum Discussion
Solved
Referencing Cell with Multiple Dates
Hi all, Example of cells in sheet 1: UnitID Date Value test123 01/31/2023 1 test123 02/28/2023 2 test123 03/31/2023 3 Example of cells in sheet 2: ...
=IFNA(INDEX($C$4:$C$8,MATCH(1,(B$12=$B$4:$B$8)*($A13=$A$4:$A$8),0)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.