Re: addressing

Article View: comp.apps.spreadsheets

Article #388

Back to comp.apps.spreadsheets Previous Next

#388

From: karl gauss
Date: Thu, 18 Mar 2004 03:27

22 lines
1949 bytes

On Tue, 16 Mar 2004 22:35:19 GMT, Harlan Grove<hrlngrv@aol.com> wrote:

>>In cell B:A1, what does the formula
>
>@INDEX($A:$A$1..$A:$A$30,0,@CELL("Sheet",B:A2))
>
>produce?

you've cracked it! after looking up the @index and @cell functions,
and struggling with them for a little while, i think i'm on to it. 

am I right? the $A:$A$1..$A:$A$30 is to define the block from which
the names are drawn; the 0 tells what column in which a name is found,
and the @CELL("Sheet",B:A2) gives the row in which the name is found -
the @CELL("Sheet",B:A2) produces differing row values depending on
which sheet i'm on. this is the correct interpretation yes?

i must say, i'd never have been able to construct your solution
without a solid knowledge of these functions *beforehand*. i'd guess
you were a professional, and i am quite grateful for your help.

karl.

Technical Details

Message-ID: <405914be.196521882@news1.sympatico.ca>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!border1.nntp.ash.giganews.com!nntp.giganews.com!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail

References: <40576c95.87924662@news1.sympatico.ca> <HiL5c.6458$_4.363@www.newsranger.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f75a7,2118e0862845590a
X-Google-Attributes: gidf75a7,public
X-Google-Thread: 107c76,2118e0862845590a
X-Google-Attributes: gid107c76,public
X-Google-ArrivalTime: 2004-03-17 19:44:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!border1.nntp.ash.giganews.com!nntp.giganews.com!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
From: hato@rio.br.com (karl gauss)
Newsgroups: comp.apps.spreadsheets,corel.support.wordperfect8suite.quattropro
Subject: Re: addressing
Message-ID: <405914be.196521882@news1.sympatico.ca>
References: <40576c95.87924662@news1.sympatico.ca> <HiL5c.6458$_4.363@www.newsranger.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 22
Date: Thu, 18 Mar 2004 03:27:18 GMT
NNTP-Posting-Host: 209.226.150.45
X-Complaints-To: abuse@sympatico.ca
X-Trace: news20.bellglobal.com 1079580544 209.226.150.45 (Wed, 17 Mar 2004 22:29:04 EST)
NNTP-Posting-Date: Wed, 17 Mar 2004 22:29:04 EST
Organization: Bell Sympatico

Reply to Parent Message