How to have same function as Excel (Index Match)

AnAnnie
AnAnnie
in Academy Discussions

3.3.5.2B Shipping Line Items

  • Shipping Method: Show the standard shipping method for the SKU. 
  • Shipping Time Weeks: Show the shipping time associated with the shipping method.
image.png

What formula can show the distribution center is Paris when beginning inventory is more than 1.

Answers

  • AjayM
    AjayM

    Hi @AnAnnie ,

    Sorry but your activity# screenshot, module screenshot and the question, look unrelated. May I know what exactly you are trying to achieve?

    For 3.3.5.2B, you might want to use the hints provided, to fetch respective values from distribution center details module and shipping metrics by week module, with the help of lookups as required.

    image.png

    Cheers!

Categories