no, unfortunately our corporate culture is "no division can understand what the other does, under any circumstances" so that will never happen as much as I would love to... I figure there is some way to say hey excell look for text='widget 1' and return the value from the column in that row for 'number on hand'

before I started this project there were 5 workbooks for inventory, and we did 5 inventories each month...