Forum Discussion

tintin ting's avatar
tintin ting
Copper Contributor
Aug 04, 2018
Solved

Inventory input of items that are same price within certain days but different quantity.

Hi, Thanks for reading my questions.  May I know the user-friendly ways to input 4 different items that are the same price a, b, c, d within a certain period of time. However, the amount we order e...
  • SergeiBaklan's avatar
    Aug 04, 2018

    Hi,

     

    You may create your price list first, and pick-up price from it for your orders

    In orders items better to select using drop-down list

    Price will be calculated as

    =IFERROR(INDEX($C$4:$C$7,MATCH($F4,$B$4:$B$7,0)),"")

    The mock-up is attached

Resources