Use the RELATEDTABLE function to lookup a table with all rows related to the current row. Use the LOOKUPVALUE function to return values by filter criteria. VLOOKUP is not available in Power Pivot but you can use a custom formula (listed in this topic) to perform similar lookups.

