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