Here's my question. I have a list of equity stock tickers. Thest stock
tickers are used by a third party application to pull data into my
spreadsheet based on the stock ticker. However some of the tickers can't be
read by the third party application. I know what the new tickers should be
for these stocks. Is there a way to build a table or something so that when
these tickers show up in my spreadsheet, they are converted to the ticker
that the application can read that is pulling data into my spreadsheet? Hope
that make sense. Thanks.