I am trying to write a formula for Excel that will allow me to create 6 column page to enter an inventory data sheet. This would consist of an item #, Item description, manufacturer, case size, Price and how sold (cs or ea). I am looking at entering all of my inventory based on downloaded price sheets on one tab and then using a second (or multiple) tabs for my inventory based on how I have it arranged in my warehouse. I want to use the item # as the base for searching for and updating the data in the Identifying cells. Any thoughts and help would be greatly appreciated!
