DAX to match two columns in two tables and return value in lookup table

[Tmk123]

Relatively new to Power BI.  I need help with some Dax that will match the Item in Table A with the Item in Table B and return the Vendor associated with that text match.  

-The first row in Table A should return "Ford"

-The second row in Table A would not have a match and should remain blank

I could not find any help with this issue in the forum.  I only saw questions asking for matching confirmations, not returning a value like in another column.  Thanks All!  You are so helpful.

Table A
Item	Vendor
abc123
abc234

Table B
Item	Vendor
abc123	Ford
abc555	Tesla
abc321	Toyota

[Dangar332 · Accepted solution]

hi, @Tmk123  

try below

LOOKUPVALUE('Table b'[vendor],'Table b'[item],'Table a'[item])

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @Tmk123 ,

the DAX function you have to use is LOOKUPVALUE. See here for an explanation of this function https://dax.guide/lookupvalue/
Be aware that LOOKUPVALUE assumes that an item only has one vendor, if an item is provided by more than one vendor an error is raised, but this is also explained in the article.

Hopefully, this helps to tackle your challenge.

Regards,

Tom