=IFERROR(INDEX("Spilletider!"&O&G$1:U&G$1;MATCH($ B2;"Spilletider!"&A&G$1:D&G$1;0));0)

Without having to use INDIRECT, see if this does what you want:

=IFERROR(INDEX(Spilletider!$O:$U;MATCH($B2;INDEX(S pilletider!$A:$D;G1;0);0);G1);0)

--
Biff
Microsoft Excel MVP


"HebbeLille" wrote in message
...
Hopefully somebody can tell me what's wrong with this formula:

=IFERROR(INDEX("Spilletider!"&O&G$1:U&G$1;MATCH($B 2;"Spilletider!"&A&G$1:D&G$1;0));0)

This one works:

=IFERROR(INDEX(Spilletider!$O$2:$R$2;MATCH($B2;Spi lletider!$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.

--
HebbeLille