I have one sheet with:
- column A filled with dates in ascending order
- row 1 filled with currency tickers (USD, JPY, EUR, AUD, CHF)
several other sheets each named exactly as the currency tickers
each sheet as column A filled with dates in ascending order, column B with the currency daily average
I am trying to fill cells in my first sheet with values from the other sheet based on the row’s date in column A and the column’s ticker name in row 1 as the sheet name to look at.
assuming I am in ROW 547 and COLUMN G , I am using this formula in my first sheet:
but I am stuck with the MATCH formula:
as it appears like the range $A$1:$A$1000 is in the same sheet where the formula is and not in the one named in the cell G! as I am hoping.
any help is appreciated…