Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Lookup Formula
I have created a spreadsheet that tracks stocks. Currently, there is a column for: 1) ticker 2) last price 3) high of the day 4) low of the day 5) all time high 6) all time low The information is pulled from a proprietary source. However, everything relies on the ticker. For example, to get the last price of ExxonMobil, I type in Excel: =ilx|q'xom,last'. Is there a formula that can go over 6 spaces after the = and change the ticker depending on what ticker is entered in the corresponding row? I am looking to just drag down the forumla to get the last price, high, low, etc. and only have to input the tickers to get the information for each stock instead of changing each formula to match the corresponding ticker. Am I making sense? I am terrible at describing what I am looking for. Sorry. -- sabunabu ------------------------------------------------------------------------ sabunabu's Profile: http://www.excelforum.com/member.php...o&userid=29395 View this thread: http://www.excelforum.com/showthread...hreadid=495015 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Lookup Formula
Hi, not sure if this is what your looking for but try this: if ticker is in column A ="ilx|q'"&INDIRECT("A"&ROW())&",last'" HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=495015 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
What formula can I set up to do a cross lookup in an Excel table? | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions |