Excel Table Usage

I have a complete inventory data set on sheet 1 in excel, i want to be able to call a line from that sheet into a new on ie. type in product code and all details to show (title, price etc)