Forum Discussion
Solved
INDEX(XMATCH) return xx:xx
Trying to figure out how to solve this. This table contains all figures; And in this table I want to have the "Time" populated for every day: What to put in cell K3? I want it to show ...
=IFERROR(INDEX($E$3:$E$18,MATCH(1,($B$3:$B$18=$H5)*($D$3:$D$18=$I5)*($C$3:$C$18=$J5)*($A$3:$A$18=K$4),0)),"")
This formula works in my file. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Hi carsten510
Given you seem to have only 1 Time per What/InOut/Who I would do it with a Pivot Table (attached)
- Thanks! I used the other solution, since I added more elements, and couldn´t find a nice table with Pivot.
- You're welcome & Thanks for providing feedback
Feel free to click on 'Mark as solution' (at the bottom of each reply you get here) to help people who Search - Thanks
