sunderlalrwr
New Member
I need an excel formula to allocate stock of an item based on column"FIFO_Rank" in Table-1 from stock Table-2.
TABLE-1
ITEM SO Qty FIFO_Rank Stock_Allocation
Chair 11 72
Table 50 14
Chair 14 99
Chair 20 36
Table 25 20
Table 20 49
TABLE-2
Item Stock
Chair 30
Tables 50
Please help.....
TABLE-1
ITEM SO Qty FIFO_Rank Stock_Allocation
Chair 11 72
Table 50 14
Chair 14 99
Chair 20 36
Table 25 20
Table 20 49
TABLE-2
Item Stock
Chair 30
Tables 50
Please help.....