grab data from one sheet and put it into another

[ecrader]

Hello!

I have two documents with very similar information. Some rows are duplicates. However, there is one column of information missing from the 1st spreadsheet. Let's call them Sheet1 and Sheet2.

How do I tell Excel:
In Sheet1, IF A2 matches any field in Sheet 2, column A

Then: copy the data from the same row, in a different column (Sheet1 A3) and put it into a specific corresponding cell (Sheet2 A3)

Basically I'm trying to grab a product ID from sheet2 and put it in the matching cell, for that specific product. I have all teh product IDs in column A in sheet 2. The product IDs field in Sheet 1 is blank. I need to populate it with teh correct information from Sheet 2. But there are many moreproducts in sheet 2 than in sheet 1, so I can't just sort and do a copy paste. It needs to think "if the product exists in sheet 2, grab the info from sheet 2 and put it into sheet 1 for that product id."

Any ideas?

Thanks in advance!
Emily

[JBeaucaire]

I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

Here's a sample sheet showing exactly what you're looking to do.
INDEX-MATCH-Simple.xls

[ecrader]

That's exactly what I'm looking for! Thank you SO much!!

[ecrader]

I spoke too soon. Can you please look at my file and tell me what I'm doing wrong? I seem to be stuck. http://furnitureusa.com/formula.xls

All i want to do is create a formula which says:

Look at the tab testing-allproduct C2. If that value exists in the tab name store-allproduct, cell c2, then take the value from store-allproduct cell a2, and put that value into testing-allproduct cell A2.

But all I get is NA! Any help you can offer would be very much appreciated!