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

Feature Requests
31

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(VLOOKUP(A1:A,(IMPORTRANGE("sheet url here", SHEET1!A1:B10)), 2, FALSE))

I hope that helps you better.

4 Likes