H
HebbeLille
Hopefully somebody can tell me what's wrong with this formula:
=IFERROR(INDEX("Spilletider!"&O&G$1:U&G$1;MATCH($B2;"Spilletider!"&A&G$1&G$1;0));0)
This one works:
=IFERROR(INDEX(Spilletider!$O$2:$R$2;MATCH($B2;Spilletider!$A$2:$D$2;0));0)
but I want to replace the number 2 in
$O$2, $R$2, $A$2 and $D$2 with the value from row 1.
(In the example the value 2 is in cell G1 in the same tab as the formula is
in,
and the column shall change when the formula is copied one cell to the
right, the value G should be H.)
The value $B2 shall not be changed, the value here changes for each row.
=IFERROR(INDEX("Spilletider!"&O&G$1:U&G$1;MATCH($B2;"Spilletider!"&A&G$1&G$1;0));0)
This one works:
=IFERROR(INDEX(Spilletider!$O$2:$R$2;MATCH($B2;Spilletider!$A$2:$D$2;0));0)
but I want to replace the number 2 in
$O$2, $R$2, $A$2 and $D$2 with the value from row 1.
(In the example the value 2 is in cell G1 in the same tab as the formula is
in,
and the column shall change when the formula is copied one cell to the
right, the value G should be H.)
The value $B2 shall not be changed, the value here changes for each row.