Lookup distinct item

[MelvinGRM]

Hi, 

Hi i want to lookup an item in a distinct gallery. The code that i use doesnt work... Does someone know how to fix it? 

I want to lookup a date that matches with the gallery result ("Title" ) (Thisitem.Result)

So if the gallery say: Test 1(" project" )  i want to display the date ("datumretour") thats in the same column of the sp list in the gallery. 

Gallery: 

 

Code Gallery: 

Distinct(SortByColumns(Filter([@Uitgeleend]; StartsWith(project; TextSearchBox1.Text)); "project";If(SortDescending1; Descending; Ascending));project)

Code label in gallery (does not work):

LookUp(Uitgeleend;"project"=ThisItem.Result;"datumretour")

Thanks!

[GarethPrisk · Accepted solution]

It may be a language difference in how formulas are written, but I don't think you should have the parts of your formula in double quotes (").

LookUp formula should be:

LookUp(Uitgeleend;Uitgeleend[@project]=ThisItem.Result;datumretour)

[MelvinGRM]

thanks, it works!