Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question - Help
I wasn't shure where this fit. Is it programming or Macro or what - I obviously don't know. 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=523830 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question - Help
You want Vlookup, as in:
B9: =vlookup(b1,'Symbol Tick'!H:I,2,false) -- Regards, Fred "tagr" wrote in message ... I wasn't shure where this fit. Is it programming or Macro or what - I obviously don't know. 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=523830 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question - Help
Thanks for your help. It works great!! Jered Lubbock, Texas -- tagr ------------------------------------------------------------------------ tagr's Profile: http://www.excelforum.com/member.php...o&userid=32583 View this thread: http://www.excelforum.com/showthread...hreadid=523830 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |