Reference From Another Document

edcoyne

New Member
Joined
Sep 10, 2017
Messages
1
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,118,355
Messages
5,571,701
Members
412,413
Latest member
dvprajapati
Top