Thread: find and copy text from multiple sheets / columns

I'm a complete moron at this - its for a baseball sim league. Thanks in advance for any help!

I need to match a row from one sheet in another sheet, then copy certain data over from the second sheet to the first.

First sheet would look like this:

Player Name	Overall	Peak	P	Age	Health	Order	1Ovr	1Pk
Smith, Bob	56	97	SP	17	61	1

Second sheet like this:

Player Name     P 	Overall	Peak	Age	Health
Smith, Bob	SP	72	93	20	60

I want to copy the "Overall" and "Peak" columns from the second sheet to the corresponding name in in column a on sheet1 to the 1Ovr column and 1Pk columns. Final result would look like this:

Player Name	Overall	Peak	P	Age	Health	Order	1Ovr	1Pk
Smith, Bob	56	97	SP	17	61	1	72	93

Thanks again for any help!

Originally Posted by protonLeah

The formula below assumes that your data spans columns A - I on each page with the first name in the list on the second row (A2); On sheet1 H2, put:

=IF(ISNA(VLOOKUP($A2,Sheet2!$A:$F,3)),"",VLOOKUP($A2,Sheet2!$A:$F,3))

copy it to I2 and change the 3 to 4, then select both cells and copy down. The list on the second sheet will have to be sorted by player name.

Wow, that was fast. I should've specified one thing perhaps - the sheet on the second page will have many more names than the sheet on the first page. I'm trying to find a way to match up the names somehow.

Basically sheet 1 is a list of players available in an amateur draft, then sheet 2 is a simulation 4 years in the future. There's no way to export just the drafted players in the future, so I have to export all players and somehow match up the data.