Forum Discussion
Solved
Two-way Index Match help
Hello I need some assistance in converting some horizontal data into table format, beginning at column H in the attachment. It should be some variation on an Index Match I'd imagine but there's the...
Perhaps in H2
=INDEX($C$2:$C$26,MATCH(1,($A$2:$A$26=$G2)*($B$2:$B$26=H$1),0))&""
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Fill down, then to the right or vice versa.
Perhaps in H2
=INDEX($C$2:$C$26,MATCH(1,($A$2:$A$26=$G2)*($B$2:$B$26=H$1),0))&""
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Fill down, then to the right or vice versa.
Thank you Hans, that worked very well.