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.
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.
This is great! Will be sure to ise this in future - Thank you.