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 MI    Dec 3, 2012

user ZRosenberg said:(!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.
following is a solution to the problem