excel - One Google Docs workbook as a database for another using a script? -

disclaimer: started working spreadsheets in depth week, prior basic usage. i've read rules , relate programming, it's ignorance of programming keeps me asking specific question. i'm new this, want learn, have start somewhere.

i want create 2 separate spreadsheet documents, 1 database another. want 1 able query other in way similar vlookup() function or along lines.

these large files hence need separate documents.

i learning scripting , think there might way there. if that's case please appreciate literally started reading scripts morning , know nothing (yet) them.

all need know is, if it's possible , functions use, i'll figure out how use them. don't have working knowledge of script functions, , limited knowledge of spreadsheet functions.

the importrange() function limited 50 per spreadsheet, given how want use it, not enough. unless know work around. , want 1 cell of information @ time , doesn't need displayed, usable.

also, efficiency king since i'm working such large amounts of data. used have 1500 vlookup functions building have , sucker starting bog down. realized didn't need dynamic database aspect of sheet. killed 2 thirds of them , runs better. i'd keep way, or @ least try.

finally may have bitten off more can chew, has been fun challenge me, , i've met success far. please don't dismiss me out of hand because don't know right questions ask, or i'm trying fit square peg in round hole, has start somewhere.

thanks!

this totally possible, though find spreadsheet functions cumbersome sort of operation. google apps scripts can query , write , multiple workbooks ease. working in javascript, using javascript objects , arrays.

start reading google documentation , checking out examples.