Help with Excell formula to search and fill

Highlighted
Occasional Visitor

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!