Populating multiple cells based on data

[Eloise1]

Hi everyone,

I would like to create a sheet where, after inputting a value in any one of the first cells in column B will give me the rest of the remaining cells based on data in another sheet. I don't know how to use INDEX/MATCH to do it for all of the other cells based on one value.

Can someone please help me? I have attached my worksheet to this message.

Thank you so much!

[Glenn Kennedy]

Two formulae types are needed here, depending on whether the column is fully populated (e.g. Percentile):

=INDEX(Sheet2!$B$2:$B$102,MATCH(Sheet1!$B$1,Sheet2!$A$2:$A$102,0))

or not (T-Score)

=LOOKUP(2,1/(Sheet2!$D$2:INDEX(Sheet2!D:D,MATCH($B$1,Sheet2!A:A,0))<>""),Sheet2!$D$2:INDEX(Sheet2!D:D,MATCH($B$1,Sheet2!A:A,0)))