2 Replies Latest reply on Apr 1, 2015 2:05 AM by Jagjit Singh

    Lookup values in previous column

    Vamsi Pothineni

      I need to lookup a value from the previous column. LOOKUP() function allows you to lookup the value from the previous row, but not the previous column. We need the Beginning Inventory for this week which is equivalent to the Ending Reported Inventory Qty of previous week. So, I need to lookup previous weeks ending inventory to get this weeks beginning inventory. I did put the Fiscal Week in Rows and used the LOOKUP() function to achieve this, but the users don't like the current layout and want to have the fiscal week in the columns. Please suggest any ideas. Attached are the screenshots of the current layout and the formula being used for Beginning Inventory calculation.