I have a master inventory sheet with 2 tabs. First tab is the master inventory....first column: Item #, 2nd: current inventory. At the end of each day a report is pulled into the same book on a different tab(titled 'daily sales'), first colum: Item #, 2nd column: total sold for the day. I need a formula (maybe vlookup, but not sure) to look up the item # on the daily sales tab, and subtract the total sold for the day, from the master inventory tab, ultimately only updating the items sold that day. I will copy, paste special values, so that I can start over using the same formula every day.