i need to create an "active" excel spreadsheet.
basically one would punch in an item number in column A and if it matches a valid item number in our database, then columns B-F would get auto-populated with the correct corresponding data (from other database fields). here is an image that may better explain this.
Row 2 is an example of what this sheet would look like. Row 3 is an explanation of what i need to accomplish.
I would greatly appeciate some help on this one!
basically one would punch in an item number in column A and if it matches a valid item number in our database, then columns B-F would get auto-populated with the correct corresponding data (from other database fields). here is an image that may better explain this.

Row 2 is an example of what this sheet would look like. Row 3 is an explanation of what i need to accomplish.
I would greatly appeciate some help on this one!