having trouble with if functions

recordsheet.forum.xlsm


Hello, I am new but i have been racking my brain about this if function for a while. I am attempting to create a nested if function that returns a value from a database worksheet based on the name of a person entered.

=IF(ROWS(A$3:A4)>$F$1,"",INDEX(DataBase!$A$2:$A$1048576, SMALL(IF(DataBase!$B$2:$B$1048576=Athletname,ROW(DataBase!$B$2:$B$1048576)-1),ROWS(A$3:A4))))


this is the function that i am using.
so it states if the row count is greater than the number of data sets put nothing. otherwise index "database is the sheet name" if the database cell = the athlete name. type smallest value from the database.

now my problem is it works on the first line of my spreadsheet but when i copy it down i get #num error

but if i highlight the portions individually and hit F9 to calculate them out it will give me the right value.

I bolded all the worksheet names and name ranges.

my question was probably confusing so i posted a copy of my file hopefully that makes it easier.