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 |
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 |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com