Program Not Pulling Correct Data

The program is pulling the part number I type in however I need it to say the price and other information about the part number I type in. Can someone help I have viewed all the tutorials and nothing really seems to help. Can anyone please help me with pulling the information from the spreadsheet?

Sorry. Here is the code to the program I have created. If anyone can help it would be greatly appreciated.