Mr. takagi_sand, It is easier for us to help if you could attached a file (dummy is Ok) telling the problem you face and the result you want to get.
Regards, Hendrik ________________________________ From: takagi_sand <takagi_s...@yahoo.com> To: belajar-excel@yahoogroups.com Sent: Tuesday, 26 March 2013, 10:31 Subject: [belajar-excel] help v loop up 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
