match data to another sheet and return all the data on that row

[Guest]

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??

 

[Bob Phillips]

=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)