Array Formula which isn't populating further down the sheet

I have attached a copy of what I am working on.

On the 'Project Stock' Sheet in column C there is the following 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 formula works for the detail given in B2 - However when I change the detail in column B2 it does not populate anything in column C2.

I have also tried to add additional rows - B40 has a different product but it won't let me change the formula so it won't pull the information through from 'Do NOT Edit'

Has anyone have any idea how I can amend the formula so that when:
- B2 is edited it will populate the correct information
- Use the formula so that it can populate other cell information below B2.

Hope I have explained that correctly - First time using a forum

Welcome to the forum.

Get rid of those merged cells for starters - they should be avoided at all costs.

Next, provide a SMALL sample workbook that shows the problem AND your expected results.

1. There is no drop-down in column A in either workbook attached.
2. There is no source data in the second workbook.
3. With formulae like this and missing data, it is not easy at all to help:

=IFERROR(INDEX('C:\Users\KeeleyBuckley\Desktop\Work\[Stock Control.xlsx]Do NOT Edit'!$H$2:$H$126, SMALL(IF('C:\Users\KeeleyBuckley\Desktop\Work\[Stock Control.xlsx]Project Stock'!$B$2='C:\Users\KeeleyBuckley\Desktop\Work\[Stock Control.xlsx]Do NOT Edit'!$G$2:$G$126,ROW('C:\Users\KeeleyBuckley\Desktop\Work\[Stock Control.xlsx]Do NOT Edit'!$H$2:$H$126)-1,""), ROW()-1)),"")

Sorry, but you are going to need to take a bit more time to prepare a sample workbook that actually helps us to help you. I still have no idea what I need to be looking for.

Sorry - you are still expecting us to reverse engineer non-working formulae!

Explain in WORDS what you want the formula to do and why. What are you expecing it to popluate?

This just isn't clear to me at all - sorry.

I'm sure it is doable, but I'm not getting it - sorry. That's my fault. Someone else may follow your explanation.

Administrative Note:

It has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will add the link for you this time: https://www.mrexcel.com/board/thread...-help.1205960/)

Not all of the M-Pod categories are listed in column G of the Do NOT Edit sheet (I.E. M-Pod I+) therefore when any project corresponding to a missing M-Pod category (I.E. FX Studios) is chosen it will result in column C displaying blanks.
The array formula in cells C40 and below still references cell B2 whereas the array formula in cells C40:C77 should read:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.