Is it possible to perform, in Excel 2016, a Lookup from an Excel table (through Vlookup, other lookup/ reference functions, or its DAX equivalent Lookupvalue) into the data model (Power Pivot)?
My goal is to retrieve values from the data model into an Excel table.
The Excel table is composed of several thousands row. Each row needs to retrieve through Lookup/ reference functions a value from a table in the data model.
What would be the way to make this process the most efficient possible, from a time and resources perspective?
For example, is it possible to perform the lookup only when certain cell change?
What are the lookup and reference functions that are the most efficient?
If several hundreds of Lookups are to be performed simultaneously, how to optimize? VBA, existing tools?