Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

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

 

 

 

2 Replies