Forum Discussion

Bilal_321321's avatar
Bilal_321321
Helper I
9 years ago
Solved

VLookup help

Hi,   I need some help with Power BI pro. I am trying to replicate a vlookup we used in excel which basically is this: =IFERROR(VLOOKUP(B3*1,Mapping!$P:$Q,2,FALSE),"No Group")   I have been ab...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

     

    Hi Bilal_321321, 

     

    the Lookupvalue formula returns blank if it doesn't have a match in the lookup (lookpvalue formula) try changing your formula to this:

     

    Column = SWITCH (
    TRUE (),
    ISBLANK (
        LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] )
    ), "NoGroup",
    LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] )
)

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
9 years ago

 

Hi Bilal_321321, 

 

the Lookupvalue formula returns blank if it doesn't have a match in the lookup (lookpvalue formula) try changing your formula to this:

 

Column = SWITCH (
    TRUE (),
    ISBLANK (
        LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] )
    ), "NoGroup",
    LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] )
)

 

Regards,

MFelix

Bilal_321321's avatar
Bilal_321321
Helper I
9 years ago

Amazing!!! Thanks So much for your help MFelix. It has worked perfectly