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 

Kirim email ke