Reply
Regular Visitor
Posts: 21
Registered: ‎12-03-2018
Accepted Solution

Lookup using IF or SWITCH

Hi,

Can you please review below scenarios and provide your suggestion/s?

I have two tables and both tables are not connceted with any relationship

If table 1 country name column match with table 2 country name then comments should be “DEALER”.

Table 1 (Look Up Table)

Country Name

Brazil

Ecudor

Peru

Mexico

 

Table 2

Country Name

Comments

Brazil

Dealer

Ecudor

Dealer

Peru

 

Mexico

Dealer

Thanks


Accepted Solutions
Highlighted
Super User
Posts: 2,139
Registered: ‎09-19-2016

Re: Lookup using IF or SWITCH

Hi @tejapowerbi123,

 

In your sample data the full dataset is on both tables so the result would be Dealer in all rows.

 

Add the following column to your table 2:

Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Regular Visitor
Posts: 21
Registered: ‎12-03-2018

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.

View solution in original post


All Replies
Highlighted
Super User
Posts: 2,139
Registered: ‎09-19-2016

Re: Lookup using IF or SWITCH

Hi @tejapowerbi123,

 

In your sample data the full dataset is on both tables so the result would be Dealer in all rows.

 

Add the following column to your table 2:

Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Regular Visitor
Posts: 21
Registered: ‎12-03-2018

Re: Lookup using IF or SWITCH

Thank you so much for quick Response.