Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyLookup Value from other Table
Hi and good day to all, Can anyone help me on how can i get the value from table 01 to table 02. My Table 01 is from one of my source data and save on my PC My Table 02 is the summarized table fr...
Hi AllanBerces Try Lookup value:
Weekly_Plan = LOOKUPVALUE( Table01[Weekly_Plan], Table01[Area], Table02[Area], Table01[Week No], Table02[ID_WeekNo ] )Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
shafiz_p
Super User
Super UserHi AllanBerces Try Lookup value:
Weekly_Plan =
LOOKUPVALUE(
Table01[Weekly_Plan],
Table01[Area], Table02[Area],
Table01[Week No], Table02[ID_WeekNo ]
)
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
AllanBercesPost Prodigy
Post Prodigy