title: "Lookup" Data in PowerPivot Model-FactTables from Excel
body: <p>I have a fact table with two unique columns in PowerPivot.</p>
  
  <p>I was wondering if it is possible somehow to "Lookup" data from this table from excel.</p>
  
  <p>As an example, please see table below (which is in PowerPivot).</p>
  
  <p>My question is would it be possible to search in column UniqueID_1 and return value in UniqueID_2, and vice versa?</p>
  
  <p>I am familiar how to use cube functions for measures, but I do not know how to return strings. </p>
  
  <p>As background, this table comes into PowerPivot through PowerQuery, and I want to retrieve the table delivered by the PowerQuery without writing the table onto a spreadsheet (which is the workaround I am doing right now).</p>
  
  <p>Any clever ideas?</p>
  
  <p>Best,</p>
  
  <p>Ben</p>
  
  <p><img src="https://i.stack.imgur.com/snPPN.png" alt="Screen Shot"></p>
  
  <hr>
  
  <p>EDIT:</p>
  
  <p>Thank you for your suggestion &amp; post. 
  I'm not sure though this exactly solves my problem.</p>
  
  <p>Just to clarify, I am NOT looking for a solution to lookup data:
  - (a) residing in PowerPivot table by querying it from another PowerPivot table (can be done with "Related" or "LookupValue" function in PowerPivot)
  - (b) residing in Excel table by querying it from another Excel cell (can be done with "Lookup", or "Index"/"Match" function in Excel)</p>
  
  <p>What I am looking for is a way to lookup data:
  - (c) residing in PowerPivot table by querying it from an Excel cell.</p>
  
  <p>Below, I added an example to make this more clear.
  I tried (c) by matching a date value with the Excel-Match functionality with a date-column from a PowerPivot Table. </p>
  
  <p>The solution I am looking for can return ANY data type, not just numbers (which could be done through excel formula "CubeValue")</p>
  
  <p>I added screenshots:
  i) from the PowerPivot Table to show the table structure &amp; content
  ii) from the Excel formula I tried to use to connect to the PowerPivot table (does not work!)</p>
  
  <p>Looking forward to any suggestions!</p>
  
  <p>Best,
  Ben</p>
  
  <p><img src="https://i.stack.imgur.com/9N86Z.png" alt="i) Diagram View/Content in PowerPivot"></p>
  
  <p><img src="https://i.stack.imgur.com/YFAfm.png" alt="iii) Match function in excel (NOT WORKING)"></p>