Vlookup in Access

Powerpivot can handle millions of row easily. That's why I said its powerful.

Edit :-
Moreover, you can use sql queries directly in powerpivot, using powerquery or from the powerpivot window, to query your sql servers. This way you can avoid Access for your reporting.