Forum Discussion
Stuznet
7 years agoHelper V
Vlookup from Another Table Return Value from Column
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
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
2 Replies
- MFelixSuper User
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
- StuznetHelper V
Thank you so much, it worked.