With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, December 3, 2012
yogi_Pull Row(s) From Another Spredsheet Dynamically Based On A Criterion In The Target Sheet
Google Spreadsheet Post #912
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 3, 2012 user ZRosenberg said:(http://productforums.google.com/forum/#!searchin/docs/ZRosenberg/docs/5GlfC05nse8/af-hZUe6NXkJ) Importrange, importing a row dynamically I would like to use the importrange function to call upon rows dynamically.
Spreadsheet A: The active sheet where I want to pull data TO
Spreadsheet B: The database
Spread A, Cell A1: = A function that takes in user input
Spread A, Cell A2: =importrange("Spreadsheet B Key", Indirect(address(A1)))
Of course Address isn't the function that will work. But the idea is that Cell A1 will call for a certain row (be it a look up using the Match function perhaps) and cell A2 will importrange that row. I know how to import a row when calling for it from the beginning, but I want to use import range to call upon whatever row cell A1 calls for (and cell A1 will change).
Note: I know how to call individual cells dynamically, using match/index combo. But I cannot keep doing this due to the 50 function limit.