Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Lookup 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...
Need Help
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    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's avatar
shafiz_p
Super User
1 year ago

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

  • AllanBerces's avatar
    AllanBerces
    Post Prodigy
    1 year ago

    Hi shafiz_p Wilson_ thank you very much for the reprly. Worked perfectly.