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
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