Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I do not want to concatenate a string or show the value like "Some Text " & C12. I need to use the text in a cell as part of the formula in another cell. For Example:

I have a cell containing a date 17.02.2014. I need to use that date in a formula within another cell:

='17.02.2014'!$AV$6  

However this date needs to be pulled dynamically, for this example from E26. I would have expected it to look something like:

='&E26&'!$AV$6 

What is the correct syntax?

share|improve this question

2 Answers 2

Please try:

=indirect("E26!"&$AV$6)

EDIT Sincere apologies. I may have misunderstood the question anyway but, as mentioned by @Jacob Jan Tuinstra (with references) I think the syntax above is wrong regardless. If your date (say 17.02.2014) is in E26 and cell AV6 in the same sheet contains, say, A4 then in that sheet:

=indirect(E26&"!"&$AV$6)  

should return the contents of Sheet 17.02.2014 cell A4 - but please test this! (and revert if it does not suit).

PS Only just noticed your comment, so sorry also for delay.

share|improve this answer
    
Hey pnuts, I have tried the code and get "error: Parse error"?? –  Kieran Headley Feb 18 at 8:47

The INDIRECT function will only accept a range, as explained in the Drive Help: enter image description here

The thing with functions like NOW() and TODAY() is, that they do just that !!

The way to go is by referencing indirectly, like shown in the screenshot (C5 vs. C1).

Screenshot

enter image description here

Reference

https://support.google.com/drive/answer/3093377

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.