Help with array formula

[76chickens]

Looking for advice on array formulas.
I'm a school teacher making a spreadsheet for my school that plots children's progress in different subjects across the year. Someone helped me write this formula which I have been able to apply to different terms in the same subject (columns A:N in one table per term). What I am struggling with is adapting the formula for the tables where data is represented in columns P:AC. My array formulae are gathering the data correctly, displaying accurately but I can't get it to be in the right place. What part do I need to tweak to get the information to show in columns P:AC??
=IFERROR(INDEX(names,SMALL(IF(A$3=RscoresBaseline,ROW(names)-4,""),ROW()-3)),"")
Thanks in advance from a teacher with no Excel training who is working it out as I go along thanks to the kindness and support of members of this group... I love you guys!!

 

[jasonb75]

Your formula looks like it should work as long as your named ranges are set up correctly.

What ranges to 'Names' and 'RScoresBaseline' refer to?

 

[76chickens]

HI Jason, RScoresBaseline is the reading scores children are getting in a separate tab and each child's name is next to their score ('Names'). Rows P:AC are WScoresBaseline (writing scores). Both reading and writing have ScoresChristmas, ScoresEaster and ScoresSummer further down the sheet.

 

[76chickens]

Your formula looks like it should work as long as your named ranges are set up correctly.

What ranges to 'Names' and 'RScoresBaseline' refer to?

I think I replied the wrong way previously!

HI Jason, RScoresBaseline is the reading scores children are getting in a separate tab and each child's name is next to their score ('Names'). Rows P:AC are WScoresBaseline (writing scores). Both reading and writing have ScoresChristmas, ScoresEaster and ScoresSummer further down the sheet.

 

[jasonb75]

But what actual ranges do they refer to?

Difference Between Rows and Columns (with Comparison Chart) - Key Differences

The main difference between rows and columns are discussed in this article. Row is an order in which people, objects or figures are placed alongside or in a straight line. A vertical division of facts, figures or any other details based on category, is called column.

keydifferences.com

Everything is showing blank, which means that the formula is creating an error, in turn that means that something must be wrong with the definitions of the named ranges.

 

[76chickens]

But what actual ranges do they refer to?

Difference Between Rows and Columns (with Comparison Chart) - Key Differences

The main difference between rows and columns are discussed in this article. Row is an order in which people, objects or figures are placed alongside or in a straight line. A vertical division of facts, figures or any other details based on category, is called column.

keydifferences.com

Everything is showing blank, which means that the formula is creating an error, in turn that means that something must be wrong with the definitions of the named ranges.

It was blank because the names weren't in it for GDPR. I've just done one with fake names and this is now it looks. The names in the array sheet are all coming from RScoresBaseline even though the array on the right refers to WScoresBaseline.

 

[jasonb75]

Still waiting on the definitions for the named ranges. As I've already pointed out (twice) they are most likely defined incorrectly.

 

[76chickens]

Still waiting on the definitions for the named ranges. As I've already pointed out (twice) they are most likely defined incorrectly.

Sorry, I thought I had but must not be clear on how it is defined. Is this what you need?

 

[76chickens]

Sorry, I thought I had but must not be clear on how it is defined. Is this what you need?
View attachment 15129

Please ignore WScoresChristmas,Easter and Summer. Trying to get WScoresBaseline right before I use it to write the others.

 

[jasonb75]

RScoresBaseline is set to $BS$5:$BS$34 which is the range for WScoresBaseline. RScoresBaseline is actually in $BO$5:$BO$34. Once corrected, your formula should work.

Just so you know for later, the #REF! errors that you said to ignore are a consequence of using right click and delete.