New answers tagged worksheet-function
This requires pretty deep diving. A script would have to check the existence of files to begin with, using the Drive app. Even invoking a script by a link inserted in a document takes a bit of coding; it's better to use custom menu commands for this. This is a kind of project that would make me think whether I'm using a right tool for the job. Google ...
Solved with: =INDIRECT( ADDRESS( 4, COLUMN() ) ) ADDRESS gives me a string like "$A$1" and INDIRECT makes it a cell reference.
Top 50 recent answers are included