How to explain??...

[tagr]

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??

[Peo Sjoblom]

Sounds like you could use VLOOKUP

http://www.contextures.com/xlFunctions02.html



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"tagr" <[email protected]> wrote in message
news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=32583
> View this thread: http://www.excelforum.com/showthread...hreadid=523825
>

[tagr]

Yep - I got it to work!

Many Thanks,

Jered
Lubbock, TX