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.
=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.
- Thanks a lot! Works perfect!
