N/A Error on a dynamic named range

[PelleCadol]

Hi, I am having the oddest problem with a named range. I have made a dynamic named range, and saved it globally. The "code" is as follows:

Please Login or Register  to view this content.

This is probably not the best way to write this range, but in the end it was the way I could figure out how to bypass the trouble of finding the second occurence of a "Resultat ekskl. Værdireguleringer" in column, and making the named range based on this second occurence's cell address.

Anyhow, when I use this named range in the worksheet where I made it, it works perfectly. Absolutely no problems, I can use VLOOKUP, INDEX etc. and get the correct values. But then when I want to use the same range in another sheet (same woorkbook) i just get the N/A error.

Hopefully someone here can tell me what I'm doing wrong, because its quite infuriating :D

Thanks in advance,
Pelle

[NBVC]

Maybe you should specifically identify the sheetname in the named range formula before all the references to column B.

[PelleCadol]

I actually though it might be something like this as well, but when you insert the sheet name before the B's, it actually returns a #REF error. But thanks for the input, this is quite literally killing me :p

[NBVC]

Did you try it like this?

Please Login or Register  to view this content.

Where 'Sheet 2' is the name of the sheet. Note that you need the apostrophes around the sheetname it it not all one word.

[PelleCadol]

Ah! Haha, I was so caught up in my hatred, I forgot about that, thanks mate! Made my day at work a whole lot better