Nesting? How do I create a table to reference?
 

Tried to nest more than 8 componets but it did not work. Any help on
creating a table to reference it would be appreciated. Never done it
before. Tried the Excel help, and it was worthless.

Here is my original post that explains mo
http://www.excelforum.com/showthread.php?t=498860


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=498905

Nesting? How do I create a table to reference?
 

ok you have a two column table.starting in the lh column you type your 1k,2ac
etc going down the page,and in the cell next to each code you type the
correspomding number,also going down the page
so you end up with
1K 51126
2AC 36320
etc
is that what you want?
--
paul
remove nospam for email addy!



"mcr1" wrote:


Tried to nest more than 8 componets but it did not work. Any help on
creating a table to reference it would be appreciated. Never done it
before. Tried the Excel help, and it was worthless.

Here is my original post that explains mo
http://www.excelforum.com/showthread.php?t=498860


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=498905

Nesting? How do I create a table to reference?
 

when I click table from the Data menu, no matter what I do I get the
Input range is not valid. I have no idea how to even begin to create a
simple table.


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=498905

Nesting? How do I create a table to reference?
 

On Fri, 6 Jan 2006 18:51:47 -0600, mcr1
wrote:

when I click table from the Data menu, no matter what I do I get the
Input range is not valid. I have no idea how to even begin to create a
simple table.

Well for one thing, please don't split the same question off into a
different thread by giving it a new subject name. This question has
been answered in your original thread; something that someone coming
across THIS thread may not realise, which would result in them wasting
their time answering it here as well.

But just for reference, the Data menu doesn't have anything to do with
Paul's reply. A table (in this context) is just a range of cells that
contain:
- the value that you want to look up, and
- the value that you want returned,
in a side by side arrangement.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *