Cross search value against sheet to return partial row

[JMAndrewsV]

In sheet #1 I have a column of values. In sheet 2 I have the same values in a column in different order with corresponding figures next to them in rows.
As an example I need to be able to enter ABC in Sheet 1 Column B and have excel search sheet 2 for ABC, and once found return the values in the corresponding row from sheet 2 into sheet one next to where ABC was entered but begining in column F.
Column
B C D E F G.......
ABC 9.1 2.3 (pulled from sheet 2)

Any suggestions?
Many thanks,

 

[Peter_SSs]

See if this helps. Here's my Sheet2 (you didn't say what columns the data was in)

Excel Workbook
	D	E	F	G	H	I
1
2		GHI	1	w	gdsfg
3		DEF	8	t	ryry
4		JKL	6	q	hgjh
5		ABC	4	k	bmbm
6
Sheet2

Then on Sheet1 this formula copied across and down.

Excel Workbook
	A	B	C	D	E	F
1
2		ABC	4	k	bmbm
3		DEF	8	t	ryry
4		GHI	1	w	gdsfg
5
Sheet1

Post back with more details if this doesn't help get what you want.

 

[JMAndrewsV]

I'm not able to quite get this.
Regarding the columns:
The Symbols to match from sheet 1 with sheet two are in column B. The corresponding row in sheet 2 to copy over if the symbol from sheet 1 matches the symbol in sheet 2 column B is from column C through column U.
I keep getting #N/A right now. What may I be mistyping? Thanks.

 

[JMAndrewsV]

Correction. I think I've gotten it straight. Many thanks for your help!