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

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

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

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