How to get a pop up box in Excel.

Anybody know how to link data in two excel file which first excel file have a worksheet for search the part number and show the details of the part number into a pop up box from the second excel file.

Thanks & Rgds,