=INDEX(Sheet2!A:A,MATCH($D$2,Sheet2!$H:$H,0))

=INDEX(Sheet2!B:B,MATCH($D$2,Sheet2!$H:$H,0))

etc.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"bbrant2" wrote in message
...
Help Please!
I have worksheet1 with a name in cell D2, worksheet2 has a varity of names
in column H. If the name in D2 in located in sheet 2 column H, I'd like
for
all the infoamtion in that row to be copied back to sheet1. Is this
possible? I've tried different formulas, but am just not getting.
Can anyone please provide some help??