data validation cross reference

hi guys
here is what im trying to do
in cell d4 i have a data validation with reference points t2-t30
if cell d4 matches anything in cells t2-t30 i would like it to return the cells relevant

so if d4 = t2 i would like
d5-d10 return the values in u2-u7

can anyone help please

many thanks

Hmm, I think there may be a bit of a discrepancy here.

Do you mean you would like to return the values in U2:Y2?

hi broken

i have attached what i mean
if steve is selected in d4
then in cells d5:d10 it should return the values in u4:z4

In D5:
=VLOOKUP($D$4,$T:$Z,ROW()-3,FALSE)

dragged down.

thanks broken
much appreciated