importing data from one sheet to another

**gman1907** · 10-13-2012, 01:54 AM

Hi all. I am trying to import data from sheet 2 to sheet 1of the same book based on matching data in column a on both sheets. sheet 2 is sorted alphabetically by column a while sheet 1 is sorted using different criteria. I want to import the value in column b of sheet 2 into sheet 1 with matching data in column a into the corresponding row placing the data in column c.. can anyone help?

Thanks
Greg

**vlady** · 10-13-2012, 01:58 AM

look into index/match

Formula:

Please Login or Register  to view this content.

**gman1907** · 10-16-2012, 05:31 PM

Hello again. I think I need to be more clear on how the spreadsheets are linked. Column A of both sheets have names. In sheet one, they are arranged by type, in sheet 2 they are alphabetical. I want to be able to pull the value from column b of sheet 2 for each particular matching name in column A into the corresponding row of column c. The previous index/match example did not work. I may have done it wrong, but I checked a couple times.

Thanks.
Greg

**vlady** · 10-16-2012, 07:34 PM

If you could attach a sample workbook and indicate the expected outcome this surely will help us to analyze your query, thanks.

**gman1907** · 10-25-2012, 12:37 AM

I have attached a sample and color coded the columns that need to import from sheet 2 to sheet 1 according to the item name. Any help would be greatly appreciated.

Thanks
Greg