Conditional Formatting/Multi Use of Formulas

Good morning to all. I am new to the Excel Forum and am so HAPPY your help is available. I am having an issue with formulas an understanding which formula to use. I am currently using MS Pro 2003 Excel. What I have is an Inventory list of about 1180 items on PAGE 2. On Page 1 I have our Sales Form. My attempt to lessen the blow of "user error" and cost control. What I want to do is have the ability to input our UPC number for in one cell and then the rest of the information to automatically fill in on the ROW. (i.e. item code, color, description, cost). I have tried a VLookup, IF/THEN and it's just not working. I did create a database from PAGE 2 of the 1180 items. Any idea's to help with this dilemma...

Best regards,

IsleTurbo

EDIT: A little slow today...lol