T
tagr
Okay here goes -
On worksheet 'Main' I have a cell where I input a value, cell B1. Thi
value would be something like the letters 'CT'. This value correspond
to a line entry on another worksheet called 'Symbol Tick'. On 'Symbo
Tick' CT is listed along with about 50 others. In cell H10, which is t
the right of 'CT' on 'Symbol Tick' is the value $5.00. If I enter th
value 'CT' into cell B1 on the 'Main' worksheet I want another cell o
worksheet 'Main', cell B9, to automatically populate with the valu
associated with the entry from worksheet 'Symbol Tick', which would b
$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 B
on worksheet 'Main'.
Clear as Mud?
On worksheet 'Main' I have a cell where I input a value, cell B1. Thi
value would be something like the letters 'CT'. This value correspond
to a line entry on another worksheet called 'Symbol Tick'. On 'Symbo
Tick' CT is listed along with about 50 others. In cell H10, which is t
the right of 'CT' on 'Symbol Tick' is the value $5.00. If I enter th
value 'CT' into cell B1 on the 'Main' worksheet I want another cell o
worksheet 'Main', cell B9, to automatically populate with the valu
associated with the entry from worksheet 'Symbol Tick', which would b
$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 B
on worksheet 'Main'.
Clear as Mud?