Best way to "bring in" data from other spreadsheets

[Eric_Penn]

I was just researching the same and came across this…

>25K rows in GT, or external database. So needed!

You list your database in another workbook all together. Then you use vlookup to pull the data. you can use the importrange function directly in the vlookup or set it separately. I recently started using the importrange function directly in the vlookup to save time. It looks like this: =VLOOKUP(A1,(IMPORTRANGE( "sheet url here", SHEET1!A1:B10)), 2, FALSE)) You can do the same with with an arrayformula just widen the range and add the function at the beginning like this: =ARRAYFORMULA(VL…