Forum Discussion
Celia9
Sep 26, 2022Brass Contributor
Index Match with multiple criteria
Hello, I need to have a reference from a table with 2 headers to a different table. The number of the week and the type of planned work are horizontal in the original file. In the new table,...
OliverScheurich
Sep 26, 2022Gold Contributor
=INDEX('Original file'!$B$3:$S$34,MATCH([@area],'Original file'!$A$3:$A$34,0),MATCH(1,([@week]='Original file'!$B$1:$S$1)*(Planned!D$1='Original file'!$B$2:$S$2),0))
An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.