Names in different sheets

[Claus]

Is it possible to name arrays in 2 different sheet, when the arrays are
different. ?

For example:

Sheet1, Name = "Data" refers to A1:B5
Sheet2, Name = "Data" refers to A1:B10

I want to use this in a cell formula like this:

Danish:
=LOPSLAG(C52;INDIREKTE(VENSTRE(C52;FIND("-";C52)-1) &
"!Enhedspris");15;FALSK)

English:
=llookup(C52;indirect(left(C52;find("-";C52)-1) & "!Enhedspris");15;false)

I don't know if the commands are right in english, but it works in danish.

Hoping U guys out there can help me.


Claus Persson

PS: I've got 2 other questions in this site, where i'm missing an answer,
and I need help on these topics, so PLEASE HELP if you can.

Topics are: 1) Reduse filesize, Date 01.07.05, From Claus and 2)
Togglebuttons as drawers, Date 05.07.05

 

[Claus]

CORRECTION:

 

[Bob Phillips]

Yes it is.

For instance, on Sheet1, goto Insert>Name>Define Name ... and add a name of
Sheet1!Data and set the refers to range accordingly. Note that the n ame is
preceded by the sheet name. Then goto Sheet and repeat with that sheet name.

 

[Dave Peterson]

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Claus]

Thanks Bob

You really helped me.


Greetings from Denmark

Claus

 

[Claus]

Hi Dave

Also thank you

Greetings from Denmark

Claus