You essentially want to get the values against multiple occurences of a
string. Please check the following link

http://office.microsoft.com/en-us/ex...CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ericaamousseau" wrote in message
...
I do not even know how to ask this! I knwo it can be doen though. What I
want is for an entire row to populate on a worksheet when teh vaule of the
linked cell changes. For example

worksheet 1
A B C D E
1 Kris yes blue 0944 yes
2 Sam yes red 1233 no
3 Kris no white 0700 yes

what I would like is for cells A1, B1, C1, D1, and E1 to populate what is
in columns B, C, D, E only when a certain value is in cell A1 - this time
Kris.

worksheet 2
A B C D E
1 Kris yes blue 0944 yes
2
3 Kris no white 0700 yes

So kinda when A1 equals "kris" B1, C1, D1, and E1 follow with the data
fromt
the other worksheet. I have seen this done, but can not figure it out.
thanks for any help!