Forum Discussion

vaggrawal29's avatar
vaggrawal29
New Member
3 years ago

How to Find Lookup Values in another table in Power Query

Hi I am trying to apply lookup on a table to find corresponding values from another table. But since there are null values I want to apply another lookup using a different column in the main table and finding those values in a different lookup table. Though I am able to achieve the 1st problem but unable to apply multiple lookups.

Its the same as applying two vlookups on mutliple table by using multiple columns if a value isn't coming from the 1st column.

Need Help

1 Reply

  • artemus's avatar
    artemus
    Microsoft Employee
    3 years ago

    The code to do this looks like

    MyLoookupTable{[LookupKey = MyKeyToLookup]}?[LookupValue]? ?? MyLoookupTable2{[LookupKey = MyKeyToLookup]}[LookupValue]

     

    P.S. MyKeyLookup would be [SomeColumn] if you are in a Table.AddColumn call and need to look up based on SomeColumn.