Ask Your Question

Mikele's profile - activity

2018-11-06 01:58:26 +0200 received badge  Famous Question (source)
2018-11-06 01:58:26 +0200 received badge  Notable Question (source)
2018-05-16 14:00:48 +0200 received badge  Famous Question (source)
2018-03-13 01:49:41 +0200 received badge  Notable Question (source)
2018-03-13 01:49:41 +0200 received badge  Popular Question (source)
2018-02-03 09:01:20 +0200 marked best answer reference sheet name from cell value in match formula

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: =INDIRECT(G1&"."&ADDRESS(MATCH(A547,G1&"."&$A$1:$A$1000,-1),2))

but I am stuck with the MATCH formula:

this works: =MATCH(A547,USD.$A$1:$A$1000,-1)

this doesn't: =MATCH(A547,G1&"."&$A$1:$A$1000,-1) 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...

2018-02-03 09:01:20 +0200 received badge  Scholar (source)
2018-02-03 09:00:48 +0200 commented answer reference sheet name from cell value in match formula

you are correct, I should have used INDIRECT also in the inner part. I could make it work, thank you so much for the hel

2018-02-03 08:59:14 +0200 received badge  Supporter (source)
2018-02-03 02:01:44 +0200 asked a question reference sheet name from cell value in match formula

reference sheet name from cell value in match formula I have one sheet with: column A filled with dates in ascending o

2017-12-27 12:08:44 +0200 received badge  Student (source)
2017-12-27 12:08:35 +0200 received badge  Self-Learner (source)
2017-12-27 12:08:35 +0200 received badge  Teacher (source)
2017-12-27 09:21:50 +0200 received badge  Popular Question (source)
2017-12-27 09:00:01 +0200 received badge  Editor (source)
2017-12-27 09:00:01 +0200 edited answer format number as currency based on next cell content

Meanwhile, it seems like I have succeeded in using conditional formatting, like this: https://drive.google.com/open?id=

2017-12-27 08:59:43 +0200 commented answer format number as currency based on next cell content

Thank you Jim, very interesting, I didn't know about the TEXT function; I'll give it a try!

2017-12-27 08:58:04 +0200 answered a question format number as currency based on next cell content

Thank you Jim, very interesting, I didn't know about the TEXT function; I'll give it a try! Meanwhile, it seems like I

2017-12-25 10:00:07 +0200 edited question format number as currency based on next cell content

format number as currency based on next cell content Hello, I have a table with two columns: Column A = numbers Column

2017-12-25 09:59:30 +0200 asked a question format number as currency based on next cell content

format number as currency based on next cell content Hello, I have a table with two columns: Column A = numbers Column