Hi All,

I need to transfer overstocked inventory from one location (site West) to another (site East) but first I need to figure out which items are over stocked and where. I have a spreadsheet that lists about 3,000 items, how many I have on hand of each, and how many I'm supposed to have, for a given location. I have another spreadsheet with almost the same information for another location. 99% of the items are the same on both spreadsheets.

So let's say A1 is an item, B1 is how many I'm supposed to have, C1 is how many I have, and D1 is C1-B1.

Now let's say A1 is motor562, B1 is 3, C1 is 5, and obviously D1 is 2, at site West. How can I have excel search the East site spreadsheet for the row with motor562 in it, copy cell D in that row, and paste it into the site West sheet in E1?