Okay here goes -
On worksheet 'Main' I have a cell where I input a value, cell B1. This
value would be something like the letters 'CT'. This value corresponds
to a line entry on another worksheet called 'Symbol Tick'. On 'Symbol
Tick' CT is listed along with about 50 others. In cell H10, which is to
the right of 'CT' on 'Symbol Tick' is the value $5.00. If I enter the
value 'CT' into cell B1 on the 'Main' worksheet I want another cell on
worksheet 'Main', cell B9, to automatically populate with the value
associated with the entry from worksheet 'Symbol Tick', which would be
$5.00 (Cell H10).
If I input any other value into cell B1 that is listed on 'Symbol Tick'
I want the appropriate value to automatically be inserted into cell B9
on worksheet 'Main'.
Clear as Mud??--
tagr
------------------------------------------------------------------------
tagr's Profile: www.excelforum.com/member.php...oamp;userid=32583
View this thread: www.excelforum.com/showthread...hreadid=523825Sounds like you could use VLOOKUP
www.contextures.com/xlFunctions02.html
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
quot;tagrquot; gt; wrote in message
...
gt;
gt; Okay here goes -
gt;
gt; On worksheet 'Main' I have a cell where I input a value, cell B1. This
gt; value would be something like the letters 'CT'. This value corresponds
gt; to a line entry on another worksheet called 'Symbol Tick'. On 'Symbol
gt; Tick' CT is listed along with about 50 others. In cell H10, which is to
gt; the right of 'CT' on 'Symbol Tick' is the value $5.00. If I enter the
gt; value 'CT' into cell B1 on the 'Main' worksheet I want another cell on
gt; worksheet 'Main', cell B9, to automatically populate with the value
gt; associated with the entry from worksheet 'Symbol Tick', which would be
gt; $5.00 (Cell H10).
gt;
gt; If I input any other value into cell B1 that is listed on 'Symbol Tick'
gt; I want the appropriate value to automatically be inserted into cell B9
gt; on worksheet 'Main'.
gt;
gt; Clear as Mud??
gt;
gt;
gt; --
gt; tagr
gt; ------------------------------------------------------------------------
gt; tagr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32583
gt; View this thread: www.excelforum.com/showthread...hreadid=523825
gt;
Yep - I got it to work!
Many Thanks,
Jered
Lubbock, TX--
tagr
------------------------------------------------------------------------
tagr's Profile: www.excelforum.com/member.php...oamp;userid=32583
View this thread: www.excelforum.com/showthread...hreadid=523825
