if then statement (i think) or vlookup

[Ann]

i'm trying to create this formula:
tow 1: if col A = "text" then take the data in col B and C and paste all 3
into a new worksheet where I already have "text" defined
so....

worksheet 1
col A col B col C
row 1 mike 5 6
row 2 ted 3 4

worksheet 2
ted <formula here> <formula here>
mike <formula here> <formula here>

i want regardless of the order in worksheet 1, to find ted from worksheet 1
and fill in the corresponding columns. hope this makes sense.
tia

 

[Pete_UK]

Put this in B1 of sheet 2:

=VLOOKUP(A$1,Sheet1!A:C,COLUMN(B1),0)

Copy into C1, then copy B1:C1 down for as many rows as you need.

Hope this helps.

Pete