Using a Lookup Formula

[sabunabu]

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.

 

[pinmaster]

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