Array Formula HELP!

[Belucky]

Hi

One of my first times using a forum so please bear with me

I have a workbook with multiple sheets on it. In Column C I have the formula =IFERROR(INDEX('Do NOT Edit'!$H$2:$H$126, SMALL(IF('Project Stock'!$B$2='Do NOT Edit'!$G$2:$G$126,ROW('Do NOT Edit'!$H$2:$H$126)-1,""), ROW()-1)),"") This populates information from a secondary tab.

This formula matches the data that is in B2 to G2 on the second sheet. If the data matches then column H will be populated back into column C on the first sheet.

My problem is:
- The formula in Column C works fine until Column A ( A dropdown box) is changed and Column C stops working.
- This is also the same for when you change the Column A Dropdown box for rows past 39 and it doesn't populate column C either.

I need to know how to I change the formula in C (Which semi works) so that it will always populate no matter what selection is made and for rows that go beyond 39.

I hope I've explained that ok

Thanks

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Array Formula which isn't populating further down the sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.