I have multiple sheets in a workbook. I am trying to do a vlookup or if/then formula to match the value in Col.A to the name of a sheet. So the stock ticker "L" is in my first row (row 2) and I want a formula that will look up a certain cell in the sheet that is named "L" - in my case it's the closing price at September month end which is G2. I have several stock tickers I want to do this for. G2 is the location of the price on all of the sheets.
I tried creating a macro but I'm not all that experienced.Yahoo.xls
Bookmarks