IF Statement not pulling all data from one worksheet to another

[kingsdime29x]

Hello! I am running into difficulty trying to use an IF statement to try and pull data from one worksheet (NHL Playoffs Schedule (1983)) and apply it to another worksheet (Playoff Gamelog (Skating)).

The problem I have is that I need to get the data from the Series and Series GM columns. However, it will work on the first line. But if I try to apply it to all rows in question.

For the Series column in the Playoff Gamelog (Skating) workbook, I have the IF statment set to:

=IF(Date='[NHL Playoffs Schedule (1983).xlsx]BOS'!$B:$B,'[NHL Playoffs Schedule (1983).xlsx]BOS'!$E:$E)

But it will only work for the first row


For the SeriesGM column in the Playoff Gamelog (Skating) workbook, I have the IF statment set to:

=IF(Date='[NHL Playoffs Schedule (1983).xlsx]BOS'!$B:$B,'[NHL Playoffs Schedule (1983).xlsx]BOS'!$F:$F)

However, it will only work for the first row.

I have included these workbooks as well. Can someone let me know how I can make this work for all rows based on the date from the NHL Playoffs Schedule (1983) and apply it based on that date.

Thank you in advance for your help with this!

[Bernie Deitrick]

You need to use an array-entered formula (entered using Ctrl-Shift-Enter) like

=IFERROR(INDEX('[NHL Playoffs Schedule (1983).xlsx]BOS'!$E:$E,SMALL(IF('[NHL Playoffs Schedule (1983).xlsx]BOS'!$B$2:$B$100=Date,ROW($B$2:$B$100)),ROW(A1))),"")

and then copied down until it returns blanks.