Hello,
The matter is rather simple.
I have an imported data model in the power pivot (over 1.5 mil rows) and I need to filter/lookup a certain field with the values from another table (few thousand rows).
Basically I'm trying to use a VLOOKUP from values in a table of over 1.5 mil rows with values in a smaller table with few thousand variables.
I guess I must create a relationship between the two tables and then write a query.

Can you please help me with the steps I need to follow in order to make this happen? (microsoft office excel 2016)

Thank you very much.



George