Vlookup from Another Table Return Value from Column

[Stuznet]

Please help, I'm currently struggling getting the same result from Excel in to Power BI. So basically I need to do a vlookup from table 1 and table 2 and returned result from Table 2 Column E and F. 

CTR Column 

=VLOOKUP(S2,'Table 2'!$C$2:$F$57310,3,FALSE)

3 is where the result returned from Table 2 Column E

CTR Status

=VLOOKUP(S2,'Table 2'!$C$2:$F$57310,4,FALSE)

4 is where the result returned from Table 2 Column F

 

I've tried this vlookup formula but it doesn't seems to be working or not the result I wanted.

Can someone please help? 

Thank you

[MFelix · Accepted solution]

Hi   @Stuznet,

In DAX you should use the LOOKUPVALUE formula (see documentation here😞

LOOKUPVALUE( Table2[CTR_Num, Table2[VI_Key], Table1[VI_Key])  

Regards,

MFelix

[Stuznet]

Thank you so much, it worked.