Dear Takagi Sand, You need a macro rather than formula. Please see attached file.
Regards, Kid. On Tue, Mar 26, 2013 at 10:31 AM, takagi_sand <[email protected]> wrote: > ** > > > in 'update' sheet, F column, the current value of quantity should be added > with > value in 'IN' sheet, D column. > > in 'IN' sheet if i choose an item from dropbox (c column) and put quantity > of 10, > then it should be added with the current value in 'UPDATE' column F sheet > for the same named item. > > i tried this formula (this is nonsense formula come to my head) but fail > in 'update!f7, sheet > > =f7+(vlookup,purchase,2,false) > > thank you in advance > > >
re-Update_data.xlsm
Description: Binary data
