VLookup returning a whole row of data?

[Excel Ron]

I am trying to figure out how to use the vlookup formula to return a whole row of data. On one sheet I have all the data with account numbers. I want to match those account numbers and when it matches that I want it to return the whole row of data. Any help would be great.

 

[texasalynn]

you will need to have a vlookup on each part, so you can setup your formula to copy across the columns. Example:

Excel Workbook
	A	B	C	D
1	Accounts	Name	Flavor	Type
2	XX46IJ46	Joe Smith	Mint	S
3	CI88DG12	Don Juan	Chocolate	D
4	GN91VH82	Jose Curavo	Vanilla	A
5	HZ14AX82	Don Rickels	Strawberry	D
6	JG12OE23	George Michaels	Rock Road	S
7	OX61EM19	Tom Jones	Bubble Gum	A
8	PX54OU23	Carol King	Orange Sherbert	S
9	WV38EM82	Tim Burton	Tutty Fruity	A
Sheet2

Excel 2003

Excel Workbook
	A	B	C	D
1	Accounts	Name	Flavor	Type
2	WV38EM82	Tim Burton	Tutty Fruity	A
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B2	=VLOOKUP($A2,Sheet2!$A$1:$D$10,COLUMN(B2),0)
C2	=VLOOKUP($A2,Sheet2!$A$1:$D$10,COLUMN(C2),0)
D2	=VLOOKUP($A2,Sheet2!$A$1:$D$10,COLUMN(D2),0)

so the formula in B can be copied across for as many columns as you need

 

[sameerkol007]

Thnx a lot texasalynn
the discussion is very helpfu