problem with =index formula

[abrunstad]

Is it possible to use this rule between sheets in a document?
I get the errors "value not defined" - why?


My formula looks like this when i try it;

=INDEX($B67:$G73;COMPARE((SHEET 2!)B5;$A67:$A73;1);COMPARE((SHEET 2)B18;$B66:$G66;1))

Thanx alot people!
-Andreas

[martindwilson]

dont know what you are tring to do but to return a match from a cell on sheet 2 with a range on sheet2
=INDEX($B67:$G73;MATCH(Sheet2!B5;Sheet2!$A67:$A73;1);MATCH(Sheet2!B18;Sheet2!$B66:$G66;1))

[NBVC]

Should it be this in Norwegian?

=INDEX($B67:$G73;SAMMENLIGNE('SHEET 2'!B5;$A67:$A73;1);SAMMENLIGNE('SHEET 2'!B18;$B66:$G66;1))

[abrunstad]

Well, I tried the formula you posted without any luck.

Exel seems not to understand the

('sheet 2'! e14) or;
(sheet 2! e14) or;
sheet 2 e14 or;

by the way, my "sheet 2" is called SGR, but this should not make any impact?
(ofcourse I've changed the sheet 2 to SGR in my rule.

Again a reminder of the code;
=INDEKS($B67:$G73;SAMMENLIGNE('SGR!E6;$A67:$A73;1);SAMMENLIGNE('SGR'!E7;$B66:$G66;1))

INDEKS = INDEX
SAMMENLIKNE = COMPARE

[NBVC]

What error are you getting? Or are you just getting the wrong answer?

I did notice an apostrophe missing in your formula:

=INDEKS($B67:$G73;SAMMENLIGNE('SGR'!E6;$A67:$A73;1);SAMMENLIGNE('SGR'!E7;$B66:$G66;1))

Also, are you looking for exact match? Or an approx match with colum A and Row 1 heading listed in ascending order? The way you have formulated the formula is per the latter...

If you want exact match, then:

=INDEKS($B67:$G73;SAMMENLIGNE('SGR'!E6;$A67:$A73;0);SAMMENLIGNE('SGR'!E7;$B66:$G66;0))