Think this should work, as-is (albeit untested*):
=IFERROR(INDEX(INDIRECT("'Spilletider'!O"&G$1&":R" &G$1);MATCH($B2;INDIRECT("'Spilletider'!A"&G$1&":D "&G$1);0));0)
where the variable is G1: 2

*as my xl03 doesn't have IFERROR, and my separators are commas, not
semi-colons. But I believe the expression above should work for you

voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"HebbeLille" wrote:
Tested out this one, and it works:

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

But, as you can see, I had to remove the !"&"A"&G$1"&":D" with !A2:D".

Any idea how I can get this part also to work as intended?