Level 2 sprint 3 activity 3.3.4 TRA01

Options
rps98
rps98 Member, ALL USERS Posts: 5 Occasional Contributor

I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now.
Please guide me through this if someone can. 

Thanks
Raj

Comments

  • shashank30
    shashank30 Member, ALL USERS, GroupMember, Partner Posts: 2 New Contributor

    Hey, could you please upload the screenshot of your query so everyone in the community has a clear picture regarding your doubt and then we can help you in a better way.

     

     

    Regards,

    Shashank

  • rps98
    rps98 Member, ALL USERS Posts: 5 Occasional Contributor
    Thanks for answering. i was able to construct the formula. I eventually didn't use LOOKUP. Thanks for explaining