Reference From Another Document

[edcoyne]

I need to reference another document, to complete the information in a particular cell.

Document #1 "Manufacturers" (information source)
Manufacturer ----- ID
ABC --------------- 12345
DEF --------------- 23456
GHI --------------- 34567


Document #2 "Parts" (information target)
Part -------------- Manufacturer ------------ ID
00001 ----------- ABC ----------------------- (need to get the matching MFG ID to go here)
00002 ----------- ABC ----------------------- (need to get the matching MFG ID to go here)
00003 ----------- GHI ----------------------- (need to get the matching MFG ID to go here)
00004 ----------- GHI ----------------------- (need to get the matching MFG ID to go here)

The sheet contains almost 8000 parts, so I need to have the part's MFG ID filled, according to its respective Manufacturer.