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

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.
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)

Hello and welcome to the forum.

To attach a sample workbook, click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

trying to attach file, see if this works

It did not.

Go Advanced > Manage Attachments > Choose File > Select the file > Open > Upload > Close this window

I did those steps for attachment, but will try again thanks.

testing attachment

I found this to work in case anyone is interested =INDEX(H$8:H$12,MATCH(C$8:C$12,G$8:G$12,0))

Originally Posted by bebo021999

I dont know while table 1 inventory count is empty, table 2 can be filled with data, but just guess:

H8=VLOOKUP(G8,$C$8:$D$12,2,0)

Thanks, i modified it to D8=VLOOKUP(C8,$G$8:$H$12,2,0) to make it work for me