How search values from one table and transfer value to appropiate place in another table?

[sme102030]

Hi, i hardly use Excel so only have very basic knowledge. I have to transfer inventory numbers digitially filled in by an employee on one table, and transfer them to the correct location on a master inventory table based on Item ID numbers. The order of the items on each table do not match each other and the tables must not be modified. There are 200 inventory items on the tables.
Is there a simple forumla to do this? May you display the formula? Thank you! (I tried attaching an example file, but don't see a working attachment button)

 

[Roderick_E]

in the column on the master sheet, where you want to put the transferred data, you will use an index/match formula. Something like

 =index(range of original data,match(uid on master sheet, uid range on original sheet,0))

UID = unique id, or reference, something we can use to match from the source sheet and the master/destination sheet.

 

[sme102030]

in the column on the master sheet, where you want to put the transferred data, you will use an index/match formula. Something like

 =index(range of original data,match(uid on master sheet, uid range on original sheet,0))

UID = unique id, or reference, something we can use to match from the source sheet and the master/destination sheet.

It worked beautifully, Thank You!!