Problem with vlookupvalue

[Cednok]

Hello guys,

I have two tables

Table : Users

Table :Request

I want add colum Email on my request Table in relation with name

I Try with Vlookupvalue, no errors but no results.

Here my fonction :

Emaul = LOOKUPVALUE(Users[Name],Users[Email],'Request'[Fullname])

Can you help me please ?

[Icey]

Hi @Cednok ,

Based on my test, @jdbuchanan71 's DAX expression works well.

Has it solved your problem?

If it has, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.

Best Regards
Icey

[calerof]

@Cednok ,

Check your formula as @jdbuchanan71 's advice. First the email, then name, lastly the name as search value from your request table.

Regards,

Fernando

[Cednok]

On my File the fullname it's concatanation of Name and Surname, i have a feeling that i have one space at the begining of surname

[jdbuchanan71 · Accepted solution]

Hello @Cednok 

Its LOOKUPVALUE(<result column>, <search column>, <search value>)
So this should get you your result:

Email = LOOKUPVALUE( Users[Email] , Users[Name] , 'Request'[Fullname] )

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

[Cednok]

I just tried but it's the same no results 😞

[jdbuchanan71]

Can you share your .pbix file so I can see the data?  You can put it on OneDrive or DropBox and share the link here.