Retrieve from other table

[Anonymous]

Hello,

Let me get straight to the point. I want to retrieve data from another table based on the date.

I have two tables;

The first one is as follows: 

The second one is as follows: 

So in the column "Result" I want to have the work day of the first table, and this linked by the column "Date" and "maand forecast". 

Conclusion: I want work day 18 in my second table whereby the date is linked. 

Thanks in advance!

[AntonioM · Accepted solution]

Result = LOOKUPVALUE( TABLE1[Work day], TABLE1[Date], TABLE2 [Maand forecast] ) 

[Anonymous]

Thanks, it worked!