software

After spending some time searching for instances of INDEX, MATCH, and
WORKSHEETS and not finding an example of what I need to do, I post this
question.

The excel code shown below works when placed in the same sheet as the
table. I need to place the code in another sheet. Here is the
information.

The table quot;assignTablequot; resides in the sheet named quot;StudentCatalogquot;.
The data in the cells quot;P43quot; and quot;Q43quot; are on a sheet named quot;Mainquot; (I
tested the code with the data in corresponding P43 and Q43 cells)

What I need to do is insert - correctly - [StudentCatalog!] throughout
the formula in the quot;Mainquot; sheet and have it read the table in the
quot;StudentCatalogquot; sheet.
=INDEX(assignTable,MATCH(P43,INDEX(assignTable,,1) ,0),MATCH(Q43,INDEX(assignTable,1,),0))
I have checked many texts, tutorials, and demos. Almost all limit their
discussions to working with one sheet. Is there a general set of rules
that govern writing code within a sheet to writing within a workbook to
writing among workbooks?

Thanks in advance!--
elrussell
------------------------------------------------------------------------
elrussell's Profile: www.excelforum.com/member.php...oamp;userid=31020
View this thread: www.excelforum.com/showthread...hreadid=519908Hi!

gt; What I need to do is insert - correctly - [StudentCatalog!] throughout
gt; the formula in the quot;Mainquot; sheet and have it read the table in the
gt; quot;StudentCatalogquot; sheet.

Can you rephrase you post? It's not at all clear what you want.

If quot;assignTablequot; is named range in the StudentCatalog sheet, then
assignTable automatically points to the StudentCatalog sheet no matter what
sheet the formula is in.

Biff

quot;elrussellquot; gt; wrote
in message ...
gt;
gt; After spending some time searching for instances of INDEX, MATCH, and
gt; WORKSHEETS and not finding an example of what I need to do, I post this
gt; question.
gt;
gt; The excel code shown below works when placed in the same sheet as the
gt; table. I need to place the code in another sheet. Here is the
gt; information.
gt;
gt; The table quot;assignTablequot; resides in the sheet named quot;StudentCatalogquot;.
gt; The data in the cells quot;P43quot; and quot;Q43quot; are on a sheet named quot;Mainquot; (I
gt; tested the code with the data in corresponding P43 and Q43 cells)
gt;
gt; What I need to do is insert - correctly - [StudentCatalog!] throughout
gt; the formula in the quot;Mainquot; sheet and have it read the table in the
gt; quot;StudentCatalogquot; sheet.
gt;
gt;
gt;
gt; =INDEX(assignTable,MATCH(P43,INDEX(assignTable,,1) ,0),MATCH(Q43,INDEX(assignTable,1,),0))
gt;
gt;
gt;
gt; I have checked many texts, tutorials, and demos. Almost all limit their
gt; discussions to working with one sheet. Is there a general set of rules
gt; that govern writing code within a sheet to writing within a workbook to
gt; writing among workbooks?
gt;
gt; Thanks in advance!
gt;
gt;
gt; --
gt; elrussell
gt; ------------------------------------------------------------------------
gt; elrussell's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31020
gt; View this thread: www.excelforum.com/showthread...hreadid=519908
gt;